Comparing 2 years data sets
Hi
I urgently need help. I know a bit about pivot tables. I have 2 years data sets, sales year to date last year (2009/10) season, and then current year to date sales data. I need to compare these two years, showing % difference between the 2 years. I am able to show % total per rep/product etc. for total last year compared to cummulative this year. Our selling season starts each year around October, when they start loading the new orders. What I need to do is show this year's 4 months (oct-feb) compared to last years 4 months, and express difference as a %. I am really struggling with this. Please help if you are able to. I can send you and extract of my spreadsheet and what I have done. Please let me know.
Regards
Sedick Kahn
attach to post
you can attach your spreadsheet to your post.
Re:Comparing 2 years data sets
Dear Sedick
Send the spreadsheet to answer exactly to your issue.
Regards.
Imed