topic Re: wrong subtotals in pivot table in QlikView https://community.qlik.com/t5/QlikView/wrong-subtotals-in-pivot-table/m-p/461212#M172184 <HTML><HEAD></HEAD><BODY><P>Anita,</P><P></P><P>It seems like your expression is a little bit wrong.</P><P></P><P>Currently you have this:</P><P><EM>sum(Factuurregel_regelbedr) - </EM></P><P><EM>(sum(Factuurregel_regelbedr)/100)*(sum([Factuurregel_perc-krt]))</EM></P><P></P><P>However, if you change to this I think your totals should match:</P><P><EM>sum(Factuurregel_regelbedr) - </EM></P><P><EM>(sum(Factuurregel_regelbedr*[Factuurregel_perc-krt])/100)</EM></P></BODY></HTML> Fri, 23 Nov 2012 09:39:13 GMT Anonymous 2012-11-23T09:39:13Z wrong subtotals in pivot table https://community.qlik.com/t5/QlikView/wrong-subtotals-in-pivot-table/m-p/461211#M172183 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I get wrong subtotals in pivot table in row " totaalbedrag inc. korting"</P><P>Can someone help me out?</P><P></P><P>Enclosed file.</P><P></P><P>Thanks</P><P>Anita</P></BODY></HTML> Fri, 23 Nov 2012 09:09:19 GMT https://community.qlik.com/t5/QlikView/wrong-subtotals-in-pivot-table/m-p/461211#M172183 anitamanders 2012-11-23T09:09:19Z Re: wrong subtotals in pivot table https://community.qlik.com/t5/QlikView/wrong-subtotals-in-pivot-table/m-p/461212#M172184 <HTML><HEAD></HEAD><BODY><P>Anita,</P><P></P><P>It seems like your expression is a little bit wrong.</P><P></P><P>Currently you have this:</P><P><EM>sum(Factuurregel_regelbedr) - </EM></P><P><EM>(sum(Factuurregel_regelbedr)/100)*(sum([Factuurregel_perc-krt]))</EM></P><P></P><P>However, if you change to this I think your totals should match:</P><P><EM>sum(Factuurregel_regelbedr) - </EM></P><P><EM>(sum(Factuurregel_regelbedr*[Factuurregel_perc-krt])/100)</EM></P></BODY></HTML> Fri, 23 Nov 2012 09:39:13 GMT https://community.qlik.com/t5/QlikView/wrong-subtotals-in-pivot-table/m-p/461212#M172184 Anonymous 2012-11-23T09:39:13Z