Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Accumulation rows in pivot tables

As the subject say, I need to have an accumulation row in a pivot table but the option it's disabled.

Is there any way??

Thxs in advance..

3 Replies
Not applicable
Author

Pivot table acts differently than a strait table. Try the strait table, but you wont have the ability to expand/calaps columns.

Not applicable
Author

Try with

Pivot table for example for sales:

Expression column 1: sum(sales)

Expression column 2: rangesum (column (1), above (total column(2)))

Bye



Not applicable
Author

Oh yes Stefania! You're right! thxs.. 😉

I used: rangesum(Num,above(Num,1,(rowno()-1)))