Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How I can create a multi-level pivot table with Grand Total values in Oracle Apex

user-yudepApr 12 2023

I have a table that contains data such as:

And I have to create a report table such as:

To display such a report, I use the pivot view from the Interactive Report table. However, my problem is displaying the total columns and the main departments rows(main department1, main department2 …).

Is it possible to display such a report using Oracle Apex?
This post has been answered by Jayson Hanes - APEX PM North America-Oracle on Apr 12 2023
Jump to Answer
Comments
Post Details
Added on Apr 12 2023
#apex-discussions, #oracle-apex
1 comment
544 views