G
Guest
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?
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?