Oracle Analytics and AI

George Mattar

Dear All,

I am currently working on a progress report using the BI Publisher tool. I am utilizing a pivot table to display the amounts corresponding to specific tasks based on their accounting dates.

However, I have encountered an issue where the summation of all amounts appears in a single field, grouped by accounting date.

Can anyone help me how to use pivot table in BI Report and display the amounts of a task based on an accounting date?

Thank you in advance.

Mallikarjuna Kuppauru-Oracle

Hi @George Mattar

As per screenshot you are using Interactive option to build an BIP report with an Pivot table format. While doing Group by accounting date, try to use x axis and try for group by right selection.

About Pivot Tables (oracle.com)

Regards,

Arjun