Categories
- All Categories
- 121 Oracle Analytics News
- 21 Oracle Analytics Videos
- 14.4K Oracle Analytics Forums
- 5.5K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 47 Oracle Analytics Trainings
- 7 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 8 Oracle Analytics Industry
- Find Partners
- For Partners
Grouping Columns based on Data like MTD,QTD,YTD in OAC/OTBI
Hello,
We have a requirement to display Data based on the Time Series to group MTD Data Columns under MTD Group Column in OAC/OTBI
We can display data by placing columns side by side in the Pivot Table for Actual, Budget,Prior Year Actual, is there a way we can display Additional column as MTD as group column at above & display respective Actual, Budget MTD columns below .
Attaching Example Report Layout for Reference
Please let us know your thoughts to achieve above requirement
Best Answer
-
In Classic analytics / OTBI, you can create a UNION ALL report. Each query in the UNION ALL will correspond to each type of measures such as MTD, QTD and YTD and have a dummy column to identify the type of measure as shown below:
Final output looks like this:
1
Answers
-
@BalagurunathanBagavathy-Oracle ,
Thanks much we could achieve our layout with your mentioned approach.
Is there a way we can bring this layout without Union Query ?
0 -
If the approach helped you achieve the requirement, please accept my answer. I am afraid if there is any other approach.
1 -
@BalagurunathanBagavathy-Oracle ,
Thank you for the response, i have accepted the answer.
Just wanted to know is there a way to group columns apart from Union Query.
Do post your thoughts on this.
0 -
Very helpful information.
Thank you very much @BalagurunathanBagavathy-Oracle!
0
