topic sum of rows in pivot table in QlikView https://community.qlik.com/t5/QlikView/sum-of-rows-in-pivot-table/m-p/172059#M41758 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>I have a Pivot Table with 6 dimensions, not expanded, and I want to show total rows for each dim.</P><P>My expression must be evaluated with aggr function, because I do not want the expression for total but the real sum of rows.</P><P>It runs well with a single dimension.</P><P>I know I could solve the problem with a cyclic or drill down group, but pivot table expandable is required.</P><P>Any suggestion?</P><P>Thanks a lot!</P></BODY></HTML> Tue, 24 Aug 2010 10:46:33 GMT 2010-08-24T10:46:33Z sum of rows in pivot table https://community.qlik.com/t5/QlikView/sum-of-rows-in-pivot-table/m-p/172059#M41758 <HTML><HEAD></HEAD><BODY><P>Hi all!</P><P>I have a Pivot Table with 6 dimensions, not expanded, and I want to show total rows for each dim.</P><P>My expression must be evaluated with aggr function, because I do not want the expression for total but the real sum of rows.</P><P>It runs well with a single dimension.</P><P>I know I could solve the problem with a cyclic or drill down group, but pivot table expandable is required.</P><P>Any suggestion?</P><P>Thanks a lot!</P></BODY></HTML> Tue, 24 Aug 2010 10:46:33 GMT https://community.qlik.com/t5/QlikView/sum-of-rows-in-pivot-table/m-p/172059#M41758 2010-08-24T10:46:33Z sum of rows in pivot table https://community.qlik.com/t5/QlikView/sum-of-rows-in-pivot-table/m-p/172060#M41759 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>i'm not really aware what your trying to calculate.</P><P>Maybe here an idea: try (SUM(TOTAL &lt;[Your Dimension Field]&gt; [ValuetoSum]))</P><P>Regards</P><P>Michael</P></BODY></HTML> Wed, 25 Aug 2010 21:49:08 GMT https://community.qlik.com/t5/QlikView/sum-of-rows-in-pivot-table/m-p/172060#M41759 2010-08-25T21:49:08Z