Categories
- All Categories
- Oracle Analytics Learning Hub
- 17 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 84 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Pivot Table without summation
George Mattar
Rank 3 - Community Apprentice
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.
0
Answers
-
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
0
