Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
juarez_chu
Contributor II
Contributor II

Grand Total and Subtotals in Pivot Table

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.

dashboard.png

grand total.png

1 Reply
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.


talk is cheap, supply exceeds demand