Skip to main content
Announcements
Get Ready. A New Qlik Learning Experience is Coming February 17! 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