I have a pivot table displayed in monthly columns.
I have rows grouped by a vehicle make, then by a vehicle model.
First value: Under each vehicle make, vehicle model, and month I have a row
value displayed as a whole number. This data is supplied from separate
worksheet.
Second value: I then inserted a calculated field to display a percentage
(this percentage is displayed in each month directly below each whole number)
Fields for the calculation is supplied from the same separate worksheet as
first value.
Third value: I then inserted a calculated field to display the result of
the percentage*whole number. (First value * second value)
Individually by vehicle make and vehicle model the calculations work great,
however, when the subtotals are listed, the % and the totals DO NOT add up at
the bottom. The right hand totals add up fine.
Note: The % displayed by model are consistent across the monthly columns,
but are different for each model.

Sample of one model:
0804 0805 0806 0807 0808 0809 Total
66 54 69 59 83 47 378
65% 65% 65% 65% 65% 65% 65%
43 35 45 38 54 31 246

First line is the monthly dates:
The top (1) whole value will add correctly at the subtotal and total value
under each model, but the % and the calculated (%*top value=) bottom value
does not add up correctly.

Any help would be greatly appreciated.
--
B Rager