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.

Hi

In what format is your source data?
How are you getting the PT to calculate the percentages?
I get 57.14% as the result.

--
Regards

Roger Govier


"Dolphinv4" wrote in message
...
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.

Hi,

If you make C5 a calculated field you will get the 57% you ask for. In the
pivots toolbar you will find Formulas/Calculated Field... use this to divide
C4 by C3. Format as % and you are done.

/Sune

"Dolphinv4" wrote:

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.