We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
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:
0
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.
0 -
@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