topic Re: Can anyone help in QlikView https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/382971#M142928 <HTML><HEAD></HEAD><BODY><P>This expression is independent from [Members] label:</P><P></P><P>=Rangesum(before(sum({&lt;stagingyear={'2013'}&gt;}[AE Members]),0,ColumnNo()))</P></BODY></HTML> Fri, 31 Aug 2012 13:44:41 GMT whiteline 2012-08-31T13:44:41Z Can anyone help https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/382970#M142927 <HTML><HEAD></HEAD><BODY><P>I'm trying to add a cumulative total to my pivot table, it's nearly working...I just need a slight amendment to the code that I can't quite figure out.</P><P></P><P>I've attached a QVW which shows the table, the expression Cumulative is what I need to amend. It's currently adding up the current months data to the month before, which isn't quite right.</P><P></P><P>I need it to add the current months data to the total from the start of the year to that point.</P><P></P><P>Can anyone help?</P></BODY></HTML> Fri, 31 Aug 2012 12:54:02 GMT https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/382970#M142927 samvile18 2012-08-31T12:54:02Z Re: Can anyone help https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/382971#M142928 <HTML><HEAD></HEAD><BODY><P>This expression is independent from [Members] label:</P><P></P><P>=Rangesum(before(sum({&lt;stagingyear={'2013'}&gt;}[AE Members]),0,ColumnNo()))</P></BODY></HTML> Fri, 31 Aug 2012 13:44:41 GMT https://community.qlik.com/t5/QlikView/Can-anyone-help/m-p/382971#M142928 whiteline 2012-08-31T13:44:41Z