topic Grand Total and Subtotals in Pivot Table in QlikView https://community.qlik.com/t5/QlikView/Grand-Total-and-Subtotals-in-Pivot-Table/m-p/74009#M778809 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>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.</P><P><IMG alt="dashboard.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/200439_dashboard.png" style="width: 620px; height: 354px;" /></P><P><IMG alt="grand total.png" class="jive-image image-2" src="/legacyfs/online/200438_grand total.png" style="width: 620px; height: 292px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT juarez_chu 2020-11-25T16:16:04Z Grand Total and Subtotals in Pivot Table https://community.qlik.com/t5/QlikView/Grand-Total-and-Subtotals-in-Pivot-Table/m-p/74009#M778809 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>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.</P><P><IMG alt="dashboard.png" class="jive-image image-3" src="https://community.qlik.com/legacyfs/online/200439_dashboard.png" style="width: 620px; height: 354px;" /></P><P><IMG alt="grand total.png" class="jive-image image-2" src="/legacyfs/online/200438_grand total.png" style="width: 620px; height: 292px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Grand-Total-and-Subtotals-in-Pivot-Table/m-p/74009#M778809 juarez_chu 2020-11-25T16:16:04Z Re: Grand Total and Subtotals in Pivot Table https://community.qlik.com/t5/QlikView/Grand-Total-and-Subtotals-in-Pivot-Table/m-p/74010#M778810 <HTML><HEAD></HEAD><BODY><P>You're using distinct in your expression sum(<STRONG>distinct</STRONG> 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.</P></BODY></HTML> Sat, 21 Apr 2018 17:54:44 GMT https://community.qlik.com/t5/QlikView/Grand-Total-and-Subtotals-in-Pivot-Table/m-p/74010#M778810 Gysbert_Wassenaar 2018-04-21T17:54:44Z