Hello Experts,
I am using Rangesum with above function to get cumulative sum, expression is working fine ,but when i select a month in the chart , it's value changes to original sales value for that particular month, but my requirement is to show the cumulative for that month. Please help
expression- RangeSum(above(sum(Sales),0,rowno()))
Sample data
Month, Sales
1,10
2,0
3,40
4,30
5,10
6,10
After selecting month 4 in the chart it is showing sales assigned with Month 4
Required
It should show cumulative for the month 4 i.e. 80 (10+0+40+30)
![Img2.JPG Img2.JPG](https://community.qlik.com/t5/image/serverpage/image-id/57648iD39E99C3CB486E44/image-size/medium?v=v2&px=400)
Thanks is advance.