topic Pivot table Grand Total in QlikView

topic Pivot table Grand Total in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Grand-Total/m-p/825428#M290733 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-678405-73244/mon.PNG" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7; text-decoration: underline;"><IMG alt="mon.PNG" class="image-1 jive-image" height="499" src="https://community.qlik.com/legacyfs/online/73436_mon.PNG" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="1063" /></A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Here in this pivot table i wrote the expression for the Final Performance is like</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=if(Dimensionality()>1,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">  [Coperate SLP]*Performance,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">  )</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i want the total at the bottom as Sum (Final Performance) AS 109+0 =109. how can i write the expression to get it .</P></BODY></HTML> Sun, 14 Dec 2014 05:53:43 GMT 2014-12-14T05:53:43Z Pivot table Grand Total https://community.qlik.com/t5/QlikView/Pivot-table-Grand-Total/m-p/825428#M290733 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/showImage/2-678405-73244/mon.PNG" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3778c7; text-decoration: underline;"><IMG alt="mon.PNG" class="image-1 jive-image" height="499" src="https://community.qlik.com/legacyfs/online/73436_mon.PNG" style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;" width="1063" /></A></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Here in this pivot table i wrote the expression for the Final Performance is like</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">=if(Dimensionality()>1,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">  [Coperate SLP]*Performance,</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">  )</P><P></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">i want the total at the bottom as Sum (Final Performance) AS 109+0 =109. how can i write the expression to get it .</P></BODY></HTML> Sun, 14 Dec 2014 05:53:43 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Grand-Total/m-p/825428#M290733 2014-12-14T05:53:43Z