Pivot Table - Compare Current Year Sales To Previous Year Sales

B

BobAJones

Hello:
I'm hoping a Pivot Table can help is compare Sales by month from the current
year vs the previous year.

Level 1 - Corporate Sales
Corporate Jan Feb Mar April
2006 500,000 600,000 550,000 700,000
2005 600,000 525,000 615,000 650,000
Difference -100.000 75,000 -65,000 50,000

Drill Down to next lower level to see the following comparison by store:
Level 2 - Store Sales
Store 1 Jan Feb Mar April
2006 300,000 325,000 315,000 400,000
2005 350,000 275,000 415,000 375,000
Difference -50,000 50,000 -100,000 25,000

Store 2 Jan Feb Mar April
2006 200,000 275,000 235,000 300,000
2005 250,000 250,000 200,000 275,000
Difference -50,000 25,000 35,000 25,000

Drill to next level for Store 1's breakdown of Grocery vs Non-Grocery Sales
Difference -50,000 50,000 -100,000 25,000
Grocery Jan Feb Mar April
2006 200,000 210,000 200,000 250,000
2005 210,000 190,000 225,000 225,000
Difference -10,000 20,000 -25,000 25,000

Non-GroceryJan Feb Mar April
2006 100,000 115,000 115,000 150,000
2005 140,000 85,000 190,000 150,000
Difference -40,000 30,000 -75,000 0

Drill down to next Level to see the breakdown of Store 1's Grocery Sales by
Meat & Non-Meat, etc.

I would always want to keep the totals for each group together. Can this be
done? Are there any examples of how to do something like this?

Thanks in advance for any suggestions!!!

BobAJones
 
Top