Categories
- All Categories
- Oracle Analytics Learning Hub
- 32 Oracle Analytics Sharing Center
- 22 Oracle Analytics Lounge
- 255 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16.1K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 95 Oracle Analytics Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
We are moving this forum's discussions to a new location. During this transition, this forum will become read-only starting 15th January 2026. For any new questions, please email us at analytics-community-ww_mb@oracle.com. Thank you for your understanding and continued participation!
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Grand total in pivot table is not showing as expected
Vrinda Choraria
Rank 4 - Community Specialist
I created a pivot table to track expenses and selected 'Row' in the Grand Total to sum up all the rows. However, I've noticed that the Grand Total for the last column, "Transfer Pricing Service Fee," is not correct. It should be 81,103,435.62, but the current total is 79,419,921.72.
Tagged:
0
Best Answer
-
Hi @Vrinda Choraria,
Can you please check if the 'Aggregation Rule (Totals Row)' has been set to SUM or not for this column?
Hope this help.
Cheers,
1
Answers
-
Thanks Bhaskar
2 -
0