topic Re: Pivot Table Total Issue.... in Qlik NPrinting https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126827#M10664 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using? Are there if statement in it? May be you need Aggr() function to make this work</P><P></P><P><STRONG>Sum(Aggr(YourExpression, [Operating Unit], Month, Year, Group))</STRONG></P></BODY></HTML> Thu, 04 Aug 2016 22:48:15 GMT sunny_talwar 2016-08-04T22:48:15Z Pivot Table Total Issue.... https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126825#M10662 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>I have created one pivot table taken Operating Unit, Month, year, Group as dimension and rest in expression I want to do total for all Expression for all group something like this attached below.</P><P></P><P>I have tried <STRONG>show partial sum </STRONG>in presentation tab based on Group dimension but it doesn't show the expected result.</P><P></P><P>Thanks in Advance.</P></BODY></HTML> Thu, 04 Aug 2016 06:11:40 GMT https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126825#M10662 infosense_devel 2016-08-04T06:11:40Z Re: Pivot Table Total Issue.... https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126826#M10663 <HTML><HEAD></HEAD><BODY><P>Using a partial sum should get you a result like shown in the image. </P><P>What do you get instead? (And what's the expected result if that's not shown in the attached image)?</P></BODY></HTML> Thu, 04 Aug 2016 21:45:06 GMT https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126826#M10663 swuehl 2016-08-04T21:45:06Z Re: Pivot Table Total Issue.... https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126827#M10664 <HTML><HEAD></HEAD><BODY><P>What is the expression you are using? Are there if statement in it? May be you need Aggr() function to make this work</P><P></P><P><STRONG>Sum(Aggr(YourExpression, [Operating Unit], Month, Year, Group))</STRONG></P></BODY></HTML> Thu, 04 Aug 2016 22:48:15 GMT https://community.qlik.com/t5/Qlik-NPrinting/Pivot-Table-Total-Issue/m-p/1126827#M10664 sunny_talwar 2016-08-04T22:48:15Z