rangesum for year and month measure

[Masi_Sahargahi]

Hi all,

I have a question about using rangesum in qlikview:

I have a year, month and amount as fields; I want to show sum of amount and  also cumulative sum of amount(from beginning till that month) in another column:

year	Month	Sum(amount)	Cumulative sum(amount)
2016	10	100	100
2016	11	200	300
2016	12	300	600
2017	1	400	1000
2017	2	500	1500
2017	3	600	2100

But when I use following formula for calculating cumulative sum It doesn’t work well, it just works for months of any single year:

Rangesum( Above(Count( amount), 0, RowNo()))

Any help would be appreciated

[Gysbert_Wassenaar · Accepted solution]

Try: Rangesum( Above(total Count( amount), 0, RowNo(total)))

[Masi_Sahargahi]

It worked.Thanks in advance!