topic Pivot Set Analysis Sub Total in QlikView https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795356#M280989 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with 2 expressions</P><P></P><UL><LI>sum(Value)</LI><LI>aggr(sum({&lt;YearMonth,MATID={'1'}&gt;}Value),$(vReports_Dimensions))</LI></UL><P></P><P>The partial sum is working for the first expression and not for the second!</P><P></P><P>Any ideas?</P><P></P><P>Thanks,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">FLC </SPAN></P></BODY></HTML> Mon, 29 Dec 2014 10:13:54 GMT 2014-12-29T10:13:54Z Pivot Set Analysis Sub Total https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795356#M280989 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a pivot table with 2 expressions</P><P></P><UL><LI>sum(Value)</LI><LI>aggr(sum({&lt;YearMonth,MATID={'1'}&gt;}Value),$(vReports_Dimensions))</LI></UL><P></P><P>The partial sum is working for the first expression and not for the second!</P><P></P><P>Any ideas?</P><P></P><P>Thanks,</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">FLC </SPAN></P></BODY></HTML> Mon, 29 Dec 2014 10:13:54 GMT https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795356#M280989 2014-12-29T10:13:54Z Re: Pivot Set Analysis Sub Total https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795357#M280990 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like</P><P>Sum(aggr(sum({&lt;YearMonth,MATID={'1'}&gt;}Value),$(vReports_Dimensions)))</P><P></P><P>Regards</P></BODY></HTML> Mon, 29 Dec 2014 10:15:35 GMT https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795357#M280990 PrashantSangle 2014-12-29T10:15:35Z Re: Pivot Set Analysis Sub Total https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795358#M280991 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P>Thanks Max.</P></BODY></HTML> Mon, 29 Dec 2014 10:17:49 GMT https://community.qlik.com/t5/QlikView/Pivot-Set-Analysis-Sub-Total/m-p/795358#M280991 2014-12-29T10:17:49Z