Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Pivot table acts differently than a strait table. Try the strait table, but you wont have the ability to expand/calaps columns.
Try with
Pivot table for example for sales:
Expression column 1: sum(sales)
Expression column 2: rangesum (column (1), above (total column(2)))
Bye
Oh yes Stefania! You're right! thxs.. 😉
I used: rangesum(Num,above(Num,1,(rowno()-1)))