nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle AI and Analytics

Child Item

Grand total in pivot table is not showing as expected

Vrinda Choraria

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.

Screenshot 2025-01-10 at 12.13.06 PM.png

Screenshot 2025-01-10 at 12.16.16 PM.png

Find more posts tagged with

FDI

Fusion AI Data Platform

Accepted answers

Bhaskar Konar

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,

All comments

Bhaskar Konar

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,

Vrinda Choraria

Thanks Bhaskar

Bhaskar Konar

Glad you found it useful, @Vrinda Choraria.

Thank You!

Cheers,

Upcoming Event

Oracle AI World 2026
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…

Top Leaders