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.
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,
Thanks Bhaskar
Glad you found it useful, @Vrinda Choraria.
Thank You!