Pivot Table Grand Total Issue

  • Thread starter Thread starter John Calder
  • Start date Start date
J

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
 
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
 
Back
Top