Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to add accumulated on pivot table

for default y can put total and sub total, but I need to add accumulated on pivot table.

I have this...

Screenshot_2.png

I want this...

Screenshot_3.png

2 Replies
Digvijay_Singh

Can you explain further, not able to make out the requirement. if you can share sample data and expected output, that will help.

Anonymous
Not applicable
Author

Not sure if I figured out the issue, but I attached here an example of accumulation on pivot tables!

  • Formula pattern:

RangeSum(Before(Sum(Value), 0, ColumnNo()))


Accumulation.png

File attached.

Cheers,

Rubens