Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

Cumulative Sum in Pivot Table

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

 

Thanks in advance.

Labels (3)
0 Replies