I don't know how to update my last post.....
My requirements for weeks would be sun-sat. The first week would be the first week ending date that starts in 2010 and 2009.
example:
week 1 2010 12/27/2009 - 1/2/2010
week 1 2009 12/28/2008 - 1/3/2009
Sorry about that, I want it to compare by week #. So week 1 2010 to week 1 2009. But I would still like it to list the week dates for the weeks of 2010. Does that make sense?
I want my report to group by week(current week dates, Sun-Sat) and have seperate columns current year compared to last year Example:
2010 Date 2010 Revenue 2009 Revenue
17-Jan to 23-Jan 1,000 1,000
24-Jan to 30-Jan 3,000 2,000
When I ask for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.