Do you have "Total" rows in your data file that you're feeding into
your pivot? Maybe these are included in your pivot table
accidentally.

Try drilling into the data (double click on the grand total) and see
if there are any total rows accidentally being included.



On Jun 26, 4:33*pm, sharder wrote:
We just changed to excel 2007 and I seem to have trouble creating a new pivot
table with subtotals. I have a calculated field and I want to subtotal that
field but the number I get is way higher than what it reall should be. Has
anyone run into this before? The total the table cam up with is the 16330 and
it should have totaled to 264.
19 Total * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *16330.75 * * * *264.77

Thanks