12 Replies Latest reply: Jul 3, 2013 3:49 AM by sravan Vennu RSS

    Compare Sales for Same DAY Last Year

      The end user wants to compare sales by DATE for the same date last year.

      In the example below, 01/01/2010 Sales are $304,304, the sales listed in Same Day Last Year are for the date (01/02/2009)

      Currently I am only showing sales by actual date 01/01/2010 and 01/02/2009 but not next to each other as the end user is looking for...

      Any suggestions?

       

      Week #Day of WeekDateSalesSales Same Day Last Year
      1Friday1/1/2010$304,304$328,120


      my results:

       

      Week #Day of WeekDateSalesSales Same Day Last Year
      1Friday1/1/2010$304,034
      1/2/2009$328,120
      Saturday1/2/2010$475,357
      1/3/2009$338,492