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

    Compare Sales for Same DAY Last Year

    candice ball

      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