Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
I need it to add the current months data to the total from the start of the year to that point.
Can anyone help?
This expression is independent from [Members] label:
=Rangesum(before(sum({<stagingyear={'2013'}>}[AE Members]),0,ColumnNo()))