topic Re: Cummulative total sum in pivot in QlikView https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252605#M396243 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Sum(TOTAL Sales) - RangeSum(Above(Sum(Sales), 1, RowNo()))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156996_Capture.PNG" style="height: 260px; width: 620px;" /></P></BODY></HTML> Tue, 21 Mar 2017 14:40:29 GMT sunny_talwar 2017-03-21T14:40:29Z Cummulative total sum in pivot https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252604#M396242 <HTML><HEAD></HEAD><BODY><P>Test</P></BODY></HTML> Tue, 21 Mar 2017 14:12:31 GMT https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252604#M396242 dhananjay_capge 2017-03-21T14:12:31Z Re: Cummulative total sum in pivot https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252605#M396243 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>=Sum(TOTAL Sales) - RangeSum(Above(Sum(Sales), 1, RowNo()))</STRONG></P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156996_Capture.PNG" style="height: 260px; width: 620px;" /></P></BODY></HTML> Tue, 21 Mar 2017 14:40:29 GMT https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252605#M396243 sunny_talwar 2017-03-21T14:40:29Z Re: Cummulative total sum in pivot https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252606#M396244 <HTML><HEAD></HEAD><BODY><P>May be something like</P></BODY></HTML> Tue, 21 Mar 2017 14:45:22 GMT https://community.qlik.com/t5/QlikView/Cummulative-total-sum-in-pivot/m-p/1252606#M396244 Anonymous 2017-03-21T14:45:22Z