Pivot Table Help

C

carolini

Hi I currently have the following pivot table which shows rolling 12 month
range of data:

Area 1/1/07 2/1/07 Grand Total
A 100 200 300
B 500 600 1100
Total 600 800 1400

And I want to be able to show a % of Total for the Grand Total Column and %
Total for only the current month reporting column (2/1/07). and update every
month going forward. Next month % total for March instead of February. Can
this be done? I appreciate any help.
 

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

Pivot Table Calculations 1
Column Heading on each row in pivot table 1
Pivot table 0
Excel 2002 Pivot Table: How to modify sub and grand totals ? 0
Pivot table grand total location 1
Pivot Table Count 1
Grand Total for Rows not Working in a Pivot Table 1
Pivot Table lookup 1

Top