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.

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,