Hi folks,
I have fields Date and Value. I want to sum value cumulatively in pivot table.
When using only one dimension (Days) on rows with below expression it works;
RangeSum(above(total Sum(Tutar),0,rowno()))
But when i add MonthYear dimension as column, it starts over on every month. I need to get last month's cumulative value to current month's first day value. You can check attached image. April-1 should be 99,483,228 + 4,384,563.
![sample.PNG sample.PNG](https://community.qlik.com/t5/image/serverpage/image-id/31116i7C5317A0D39D6936/image-size/large?v=v2&px=999)
Thanks in advance.