Excel 2007 : Pivot Table Customised Formula

[makku]

I need to create a customised calculation which basically caluclates the % difference between two prices.

I managed to create the formula, however at sub-total and grand-total level i am getting an incorrect answer possibly to 0 values in some of the individual line items.

Is it possible to create the same formula outside the pivot table in a column next the actual pivot table and then easily copy down into other cells?


regards,

[romperstomper]

What is the formula and what incorrect values are you getting?
Assuming it is something like =(Field1-Field2)/Field2 you should be aware that calculated fields work at the aggregate level so your totals will be:
=(Sum(Field1)-sum(Field2))/sum(Field2)
and not:
=sum((Field1-Field2)/Field2).