topic How to do Cumulative Sum in pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-do-Cumulative-Sum-in-pivot-table/m-p/605213#M1105111 <HTML><HEAD></HEAD><BODY><P>I have one pivot table i need to do the cumulative sum for nly few rows. and i ve few filters as well in dashboard. the filters should be affecting the pivot table... pls look the attached file to get a clear view. can u pls help me out with this.</P></BODY></HTML> Fri, 21 Mar 2014 05:18:36 GMT 2014-03-21T05:18:36Z How to do Cumulative Sum in pivot table https://community.qlik.com/t5/QlikView/How-to-do-Cumulative-Sum-in-pivot-table/m-p/605213#M1105111 <HTML><HEAD></HEAD><BODY><P>I have one pivot table i need to do the cumulative sum for nly few rows. and i ve few filters as well in dashboard. the filters should be affecting the pivot table... pls look the attached file to get a clear view. can u pls help me out with this.</P></BODY></HTML> Fri, 21 Mar 2014 05:18:36 GMT https://community.qlik.com/t5/QlikView/How-to-do-Cumulative-Sum-in-pivot-table/m-p/605213#M1105111 2014-03-21T05:18:36Z Re: How to do Cumulative Sum in pivot table https://community.qlik.com/t5/QlikView/How-to-do-Cumulative-Sum-in-pivot-table/m-p/605214#M1105112 <HTML><HEAD></HEAD><BODY><P>You could cumulate in pivot-tables with expressions like this : rangesum(sum(%), above(total sum(%), 1, rowno(total))) - have a look on the attachment. But this won't work with your mixed structure from absolutely and relatively values. Generally I would suggest to separate this in two columns.</P><P></P><P>- Marcus</P></BODY></HTML> Fri, 21 Mar 2014 11:13:23 GMT https://community.qlik.com/t5/QlikView/How-to-do-Cumulative-Sum-in-pivot-table/m-p/605214#M1105112 marcus_sommer 2014-03-21T11:13:23Z