Oracle Analytics and AI

Vaigu_27

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

BalagurunathanBagavathy-Oracle

@Vaigu_27

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: