by RC5FL » Tue, 16 May 2006 17:07:01
1. Compare this year vs. previous year data in one graph (date vs. quantity)
2. Pivot Table - Compare Current Year Sales To Previous Year Sales
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
3. Query for current year dates plus December of previous year??
4. Compare this year/qtr/mo to date with prior year/qtr/mo to date
5. URGENT HELP NEEDED--compare current date file with previous day
6. Comparing quarterly sales data to previous quarter and previous year.
7. --compare current date file with previous day
8. Want previous years data to drop off as I enter current year d
9. Formula for showing Previous Year - Current Year
10. Want previous years data to drop off as I enter current year data
11. Query October 1 previous year to September 30 current year
12. Comparing current year and prior year data in one report
13. How to compare current year to prior year in bar chart?
14. Date restrictor comparing this year to last year
15. Restricting date entry relative to current date