Hi,

i have a pivot table as below:

C1 C2 C3 C4 C5
xxx AAA 1000 2000 50%
BBB 2000 2000 100%
CCC 1000 3000 33%
xxx Total 4000 7000 61%

The last column is a percentage of column C3 divide by C4. For the last row
C5, the pivot table will automatically calculate the percentage this way
(50%+100%+33%)/3 = 61%. I want this cell (ie, 61%) to be 4000/7000=57%
instead. Is it possible?

Thanks.