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.