1 Reply Latest reply on Mar 7, 2016 5:23 PM by Esther Aller

    Compare Sales different periods on same day of week

    Nakarest Chumsuntivut

      Hi,Guys

       

      I'm working on compare sales performance between this year to previous years, but the only things I can do is compare Monday,November 16 2015 to Sunday 16 January 2014.

      But as you can see comparing sales Monday with Sunday seems to be unfair, So it should be Monday,November 16 2015  compare to Monday 17 January 2014 as below picture

       

       


      I have been stuck with this for a week, try to show a result like the highlighted part in excel.
      I have attached excel I have done and also workbook that I'm working on. 

       

       


      Thank you in advanced.
      Nakarest