Skip to main content

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
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