topic Cumulative Total calculation in QlikView https://community.qlik.com/t5/QlikView/Cumulative-Total-calculation/m-p/438868#M163560 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P></P><P>Iam new to Qlikview.</P><P></P><P>Iam unable to calculate the cumulative total in pivot table.</P><P></P><P>The expression which i used to calculate the cumulatve sum is </P><P></P><P><STRONG>=if(RowNo()= 0,0,(RangeSum(Above(Column(1), 0, RowNo(TOTAL)))))</STRONG></P><P></P><P>I have attached the screenshot for your verification</P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Kindly do help ...Thank you</P></BODY></HTML> Wed, 10 Apr 2013 05:18:58 GMT 2013-04-10T05:18:58Z Cumulative Total calculation https://community.qlik.com/t5/QlikView/Cumulative-Total-calculation/m-p/438868#M163560 <HTML><HEAD></HEAD><BODY><P>Hi friends,</P><P></P><P>Iam new to Qlikview.</P><P></P><P>Iam unable to calculate the cumulative total in pivot table.</P><P></P><P>The expression which i used to calculate the cumulatve sum is </P><P></P><P><STRONG>=if(RowNo()= 0,0,(RangeSum(Above(Column(1), 0, RowNo(TOTAL)))))</STRONG></P><P></P><P>I have attached the screenshot for your verification</P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>Kindly do help ...Thank you</P></BODY></HTML> Wed, 10 Apr 2013 05:18:58 GMT https://community.qlik.com/t5/QlikView/Cumulative-Total-calculation/m-p/438868#M163560 2013-04-10T05:18:58Z