topic Pivot table final total in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-final-total/m-p/802026#M283106 <HTML><HEAD></HEAD><BODY><P><IMG alt="mon.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73082_mon.PNG" style="height: 291px; width: 620px;" /></P><P>Here in this pivot table ,</P><P></P><P>i wrote the expression as ,</P><P>=if(Dimensionality()=1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Coperate SLP]*Performance)</P><P></P><P>i got subtotals .</P><P></P><P>i want the grand total as sum of the subtotals ?? at Final Performance ??</P><P>how can i write the expression to get it ?</P></BODY></HTML> Wed, 10 Dec 2014 05:02:54 GMT Anonymous 2014-12-10T05:02:54Z Pivot table final total https://community.qlik.com/t5/QlikView/Pivot-table-final-total/m-p/802026#M283106 <HTML><HEAD></HEAD><BODY><P><IMG alt="mon.PNG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/73082_mon.PNG" style="height: 291px; width: 620px;" /></P><P>Here in this pivot table ,</P><P></P><P>i wrote the expression as ,</P><P>=if(Dimensionality()=1,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; [Coperate SLP]*Performance)</P><P></P><P>i got subtotals .</P><P></P><P>i want the grand total as sum of the subtotals ?? at Final Performance ??</P><P>how can i write the expression to get it ?</P></BODY></HTML> Wed, 10 Dec 2014 05:02:54 GMT https://community.qlik.com/t5/QlikView/Pivot-table-final-total/m-p/802026#M283106 Anonymous 2014-12-10T05:02:54Z