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,