topic Re: Tabel Total in QlikView https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160761#M378460 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>try </P><P></P><P>sum(aggr(YourExpression,Year,Month))</P><P></P><P>Regards</P></BODY></HTML> Thu, 09 Jun 2016 12:36:10 GMT PrashantSangle 2016-06-09T12:36:10Z Tabel Total https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160760#M378459 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P>I've got a pivot table with Months and years. Besides there's a better way to show the data, i'm curious as why the Tabel total for<STRONG style="text-decoration: underline;"> 2014</STRONG> doesn't match the sum of the cells.</P><P>The logic is to show and sum the last 24M (=M24Flag). (expression in the tableheader)</P><P></P><P>Can anyone tell me why?<IMG alt="tabel.PNG" class="jive-image image-1" height="85" src="https://community.qlik.com/legacyfs/online/127421_tabel.PNG" style="width: 775px; height: 85px;" width="775" /></P></BODY></HTML> Thu, 09 Jun 2016 12:26:48 GMT https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160760#M378459 joris_lansdaal 2016-06-09T12:26:48Z Re: Tabel Total https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160761#M378460 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>try </P><P></P><P>sum(aggr(YourExpression,Year,Month))</P><P></P><P>Regards</P></BODY></HTML> Thu, 09 Jun 2016 12:36:10 GMT https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160761#M378460 PrashantSangle 2016-06-09T12:36:10Z Re: Tabel Total https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160762#M378461 <HTML><HEAD></HEAD><BODY><P>That's the solution. Do you also know<STRONG style="text-decoration: underline;"> why</STRONG> the total is different from the sums? </P></BODY></HTML> Thu, 09 Jun 2016 14:38:37 GMT https://community.qlik.com/t5/QlikView/Tabel-Total/m-p/1160762#M378461 joris_lansdaal 2016-06-09T14:38:37Z