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