Totals in Pivot Table for calculated item does not agree to sum of the detail lines

[General Ledger]

Dear All,

I ran into a bug concerning automatic totals on calculated items in Pivot Tables. I am using Excel 2003.

I have two columns of summed values in a pivot table. I created a calculated item that takes the lower value between two columns and multiplies it with a rate. For example, the formula for the calculated field in column E is:
=IF(column C < column D, C * .1, D * .1)
The formula seems to work perfectly for the detail rows.

The problem is on the sub total and grand total rows. It seems Excel is using the formula to determine the value of the totals of the calculated item. Excel is not actually summing the values from the detail lines. The sum of the details does not equal the totals.

Does anyone understand why this is happening?
Is there a work around?

Best regards,

General Ledger

 

[rallcorn]

Total rows for a calculated ITEM are going to SUM all of the calculated items. The calculated item's calculation is NOT performed in/on the total row(s).

 

[Pivoting]

I ran into this situation just now using Excel 2007. Is this considered as a bug then?