topic Re: Pivot table Difference instead of total in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184991#M383508 <HTML><HEAD></HEAD><BODY><P>You can us chart inter record functions and the fact that the <SPAN style="font-size: 13.3333px;">SecondaryDimensionality()=0 for the partial sum, so e.g. for the Cost expression</SPAN></P><P></P><P>=if(SecondaryDimensionality()=0,</P><P>First(Sum(Cost))-First(Sum(Cost),2),</P><P>Sum(Cost)</P><P>)</P></BODY></HTML> Wed, 28 Sep 2016 16:35:25 GMT stigchel 2016-09-28T16:35:25Z Pivot table Difference instead of total https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184990#M383507 <HTML><HEAD></HEAD><BODY><P>Dear Experts</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Can anyone solve this simple problem which i am facing, In the below picture instead of getting partial sum i wanted actual - budget difference.</P><P></P><P>Thanks in Advance</P><P></P><P><IMG alt="QVCPic.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/138955_QVCPic.JPG" style="height: 108px; width: 620px;" /></P></BODY></HTML> Wed, 28 Sep 2016 07:44:59 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184990#M383507 2016-09-28T07:44:59Z Re: Pivot table Difference instead of total https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184991#M383508 <HTML><HEAD></HEAD><BODY><P>You can us chart inter record functions and the fact that the <SPAN style="font-size: 13.3333px;">SecondaryDimensionality()=0 for the partial sum, so e.g. for the Cost expression</SPAN></P><P></P><P>=if(SecondaryDimensionality()=0,</P><P>First(Sum(Cost))-First(Sum(Cost),2),</P><P>Sum(Cost)</P><P>)</P></BODY></HTML> Wed, 28 Sep 2016 16:35:25 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184991#M383508 stigchel 2016-09-28T16:35:25Z Re: Pivot table Difference instead of total https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184992#M383509 <HTML><HEAD></HEAD><BODY><P>Fantastic..!!!!</P><P></P><P>it works..!</P><P></P><P>Thank you very much <A _jive_internal="true" data-avatarid="10171" data-externalid="" data-online="false" data-presence="null" data-userid="41178" data-username="stigchel" href="https://community.qlik.com/people/stigchel" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; background-color: #f2f2f2;">Piet Hein van der Stigchel</A></P></BODY></HTML> Wed, 28 Sep 2016 17:25:23 GMT https://community.qlik.com/t5/QlikView/Pivot-table-Difference-instead-of-total/m-p/1184992#M383509 2016-09-28T17:25:23Z