topic Pivot Table total not proper in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551589#M555119 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P><BR />I had a pivot table like this containing two dimentions Region and Campain and one expression: count(case): As shown in attached image: I had take horizonal total by checking show partial sum for Campain Dimention. But this total is not coming perfect. For example: for Guj, it shoud come 30, but in my application it's not 30. all the '?' indicates invalid total. <BR />Is this a pivot table bug or can you please help me out?? <BR />Best Regards, Brijesh</P><DIV> </DIV></BODY></HTML> Fri, 02 Aug 2013 07:25:58 GMT brijesh1991 2013-08-02T07:25:58Z Pivot Table total not proper https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551589#M555119 <HTML><HEAD></HEAD><BODY><P>Hi all, </P><P><BR />I had a pivot table like this containing two dimentions Region and Campain and one expression: count(case): As shown in attached image: I had take horizonal total by checking show partial sum for Campain Dimention. But this total is not coming perfect. For example: for Guj, it shoud come 30, but in my application it's not 30. all the '?' indicates invalid total. <BR />Is this a pivot table bug or can you please help me out?? <BR />Best Regards, Brijesh</P><DIV> </DIV></BODY></HTML> Fri, 02 Aug 2013 07:25:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551589#M555119 brijesh1991 2013-08-02T07:25:58Z Re: Pivot Table total not proper https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551590#M555120 <HTML><HEAD></HEAD><BODY><P>Hi All, I detected the problem. By default, Pivot table has Total Mode: Expression Total. But I wanted 'Sum Of Rows' Total Mode. Now anyone please tell me how to change that total mode from 'expression total' to 'Sum of Rows'??? Brijesh</P></BODY></HTML> Fri, 02 Aug 2013 08:34:58 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551590#M555120 brijesh1991 2013-08-02T08:34:58Z Re: Pivot Table total not proper https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551591#M555121 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">You'll need the aggr function. Something like this:</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">=sum( aggr(<EM>yourexpression</EM>, Region, Campaign))</P></BODY></HTML> Fri, 02 Aug 2013 08:44:25 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-total-not-proper/m-p/551591#M555121 Gysbert_Wassenaar 2013-08-02T08:44:25Z