Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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