Cumulative expression on pivot table

[berkarmagan]

Hi,

I have a pivot table, year and month on pivot column, and i need cumulative sum(data)  like the example below. When i use just sum(data)  expression and pick Jan to May and 2015-2016 on list box the result is like the example 1, but i need a result like example 2, which is calculating cumulative by month and for just up to May for 2015 and also 2016. Is it possible? I tried range and above function but, it s getting complicated when I pick 2 years on list box. Thanks for now.

1)

		2015						2016
		Jan	Feb	Mar	Apr	May		Jan	Feb	Mar	Apr	May
Product		10	20	25	20	10		20	20	10	15	10
2)
		2015						2016
		Jan	Feb	Mar	Apr	May		Jan	Feb	Mar	Apr	May
Product		10	30	55	75	85		20	40	50	65	75

[lironbaram · Accepted solution]

hi

this expression should do the trick for you

RangeSum(before( sum(SalesAmount) ,0,columnno(TOTAL)))

replace the sum(SalesAmount) with your expression

[Gysbert_Wassenaar]

That looks like a pivot table. Try using the Before() function instead of the Above() function.

[berkarmagan]

That worked, thanks 🙂