topic Re: Strucked with sub totals in Pivot table on months in QlikView https://community.qlik.com/t5/QlikView/Strucked-with-sub-totals-in-Pivot-table-on-months/m-p/890720#M1017474 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>add month in your expression:sum(aggr(AVG(ALLOC_VAL),PRJ_NM,RSRC_NM,month))/8</P></BODY></HTML> Fri, 10 Apr 2015 08:03:33 GMT stabben23 2015-04-10T08:03:33Z Strucked with sub totals in Pivot table on months https://community.qlik.com/t5/QlikView/Strucked-with-sub-totals-in-Pivot-table-on-months/m-p/890719#M1017473 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am new to QlikView , PFA</P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">the Issue is when i clik on paricular month it is showing SUM of allocation value for the particular month but when i am selecting all the the months&nbsp; the sum of Allocation Value is Not coming&nbsp; for the months'</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Can any one help on these,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">Sruthi Reddy<BR /></SPAN></P></BODY></HTML> Fri, 10 Apr 2015 07:38:51 GMT https://community.qlik.com/t5/QlikView/Strucked-with-sub-totals-in-Pivot-table-on-months/m-p/890719#M1017473 2015-04-10T07:38:51Z Re: Strucked with sub totals in Pivot table on months https://community.qlik.com/t5/QlikView/Strucked-with-sub-totals-in-Pivot-table-on-months/m-p/890720#M1017474 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>add month in your expression:sum(aggr(AVG(ALLOC_VAL),PRJ_NM,RSRC_NM,month))/8</P></BODY></HTML> Fri, 10 Apr 2015 08:03:33 GMT https://community.qlik.com/t5/QlikView/Strucked-with-sub-totals-in-Pivot-table-on-months/m-p/890720#M1017474 stabben23 2015-04-10T08:03:33Z