Grand Total and Subtotals in Pivot Table

[juarez_chu]

Hi Guys,

Just wondering if we can create an expression in Grand Total that will sum directly the Subtotals. Somehow the default Grand Total and Subtotals are not tallying when added, maybe because I am using an expression. Appreciate any suggestions on this, thank you.

[Gysbert_Wassenaar]

You're using distinct in your expression sum(distinct aggr(current_year_forecast_total_sr,RecNo_inv))/pow(10,6). That's why 0.72 is only used once to calculate the sum. That's also the difference you see, well that and a bit of rounding difference.