Pivot Table Grand Total Issue

[John Calder]

Hi

I have WinXP with Excel 2003

I have a pivot table that has a number of calculated fields in it.

One of the calculated fields looks at a column of data that has an amout in
it and this is multiplied by another field that has a dollar figure in it.

Each line of data the Pivot Table calculates as normal. The problem I have
is that the Grand Total works correctly for all the columns in the Pivot
Table except for the ones that contain the dollar figures from the calculated
field. The Grand Total line display a dollar figure that is approximately 10
times as much as what it should be.

When I highlight the range in the Pivot Table it totals to the correct
amount, yet the Grand Total line for these figures is completely wrong. There
are five columns in the table that display a dollar amout and all of them
have the wrong Grand Total.

This has taken me nay hours to create this table and this is the only part
which does not work.

Can anyone help?


Thanks


John

 

[Bernie Deitrick]

John,

The Grand Total for the calculated item is not the sum of the individual calculated items, but the
result of the calculationa as applied to the Grand Totals row. Pivot tables are wonderful at all
things except calculations, and the easiest workaround for this is to do the calculations in your
source table rather than in the Pivot Table.

HTH,
Bernie
MS Excel MVP

 

[Herbert Seidenberg]

Excel 2007 Pivot Table
Calculated Field
Here is an explanation of
and solution to the calculated field sum problem.
http://www.mediafire.com/file/gmumjmhrygy/04_02_09.xlsx

 

[John Calder]

Thanks, that helped me overcome my problem.


John