Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
mfarsln
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 (2)
0 Replies