topic Subtotal in pivot table in QlikView https://community.qlik.com/t5/QlikView/Subtotal-in-pivot-table/m-p/590002#M1111768 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have problem with subtotal in pivot table, you can see in attached file, vol (yellow column) has a formula and calculate volume variance by material family group.</P><P>Problem is, A Total (316), B Total (-570) and Grand Total (-158) dosent calculated correctly.&nbsp; I tried aggr and dimensionaliy but I couldnt calculate correct values.</P><P></P><P>correct values; A Total it must be (83), B Total must be (-628), grand total must be (-545) </P><P></P><P>Thank You</P><P><EM>Serkan</EM></P></BODY></HTML> Sun, 02 Mar 2014 15:44:19 GMT 2014-03-02T15:44:19Z Subtotal in pivot table https://community.qlik.com/t5/QlikView/Subtotal-in-pivot-table/m-p/590002#M1111768 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have problem with subtotal in pivot table, you can see in attached file, vol (yellow column) has a formula and calculate volume variance by material family group.</P><P>Problem is, A Total (316), B Total (-570) and Grand Total (-158) dosent calculated correctly.&nbsp; I tried aggr and dimensionaliy but I couldnt calculate correct values.</P><P></P><P>correct values; A Total it must be (83), B Total must be (-628), grand total must be (-545) </P><P></P><P>Thank You</P><P><EM>Serkan</EM></P></BODY></HTML> Sun, 02 Mar 2014 15:44:19 GMT https://community.qlik.com/t5/QlikView/Subtotal-in-pivot-table/m-p/590002#M1111768 2014-03-02T15:44:19Z