"Dynamic" calculated fields in a pivot table

C

csdjj

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Slicers and Calculated Items in Pivot Table 2
Additional columns for Pivot table 0
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Calculated Item in a Pivot Table 2
Pivot Table Hide Selected Field 2007 0
Pivot Table 2007 display field only in Grand Total 0

Top