Pivot Table Formulas and Calculations. How to use pivot table data in formulas?

Hi guys,

I have the following database and based on that I generated a pivot table.
From this pivot table, I’m trying to setup the calculations (normal formulas linked to the data on the pivot table) on columns AU – BG. But there are a few problems with this approach:

1) If the pivot table tables changes, the formulas will not make the correct calculations
2) I have tried calculated field/item, GetPivotData function, but neither worked or I didn’t set it up correctly.
3) I want to use the Pivot Table approach because of its versatility when grouping the data in different ways. I want to avoid having different sheets to show different forms of grouping the data.

*I changed the original database amounts and the formulas on the pivot table are weird, but they are correct.*Database tests.xlsx

Do you have any suggestions on how to accomplish this? Any ideas? I’m using excel 2007
I have struggled with this for the past days, so I really appreciate some help.

Thanks
Alex

Did you ever find a solution to this problem? I am experiencing the same thing currently. I would really appreciate hearing what you did!

Thanks,

Alison