Pivot Table subtotals
 

Is it possible to capture the formulas that calculated subtotals in a
pivottable and carry over in columns added along side the pivot table. My
dilemma is I am working on a sales forecasting model where the 2004 numbers
are all calculated with the pivot table but now I want to add the same
columns for the 2005 Forecasting that requires user input and need to insert
the same subtotals for the 2005 data.

Perhaps you could use the GETPIVOTDATA function to extract data
from the pivot table. There are examples in Excel's Help files, and he

http://www.contextures.com/xlPivot06.html

Linda wrote:
Is it possible to capture the formulas that calculated subtotals in a
pivottable and carry over in columns added along side the pivot table. My
dilemma is I am working on a sales forecasting model where the 2004 numbers
are all calculated with the pivot table but now I want to add the same
columns for the 2005 Forecasting that requires user input and need to insert
the same subtotals for the 2005 data.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html