"Dynamic" calculated fields in a pivot table
 

Hi,

I have a pivot table that consists of 4 data columns:
Column 1 = Budget
Column 2 = Original forecast
Column 3 = Revised forecast
Column 4 = Final sales

I would like to be able to create a "dynamic" calculated field so that,
whichever column I click on, it calculates that columns data versus the
Budget.

So, if I click on column 2, it will calculate the original forecast versus
the budget; If I click on column 3, it will calculate the revised forecast
versus the budget, etc.

If there is no way to do this then is there a way to easily copy and paste a
calculated field so that I can replicate it quickly?

Thanks!