Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody ,
i have i pivot table and i have to calculate the progressive total of rows's total
I post an example so you can understand better wath i want
Thanks in advance
Try something like this into a new column
rangesum(above( total ( sum( Sales)),0,NoOfRows(TOTAL )))
Thank mauretto for your reply,
the formula works and give the right result ...., the problem is the sum is not display in the right row , i mean not display in rows of totals but in detail row...
How can display in the total row?
Thank