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.


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