Full Accumulation in Pivot Table

[#1]

Hi all,

Is it possible to show "full accumulation" enabled values in Pivot chart?

If so, how? Kindly help me on this.

Regards,

Vidhya

[ali_hijazi]

there are three types of accumulation

try the one that suites your needs:

Above

(sum(Sales))

sum

(Sales) + RangeSum(Above(sum(Sales),1,RowNo()))

sum

(Sales) + RangeSum(Above(Total sum(Sales),1,RowNo(TOTAL)))

check the attached example which clarifies what I'm talking about