12 Replies Latest reply on Jun 19, 2018 1:32 PM by Tony Smith

    How to displace and calculate the last five weeks of the current year and the last five weeks of the previous year Sales

    Tony Smith

      Hi All,

       

      Can anyone please tell me how to report and calculate the last five weeks of the current year and the last five weeks of the previous year Sales?  Please see additional information below.  I have also attached a spreadsheet to illustrate what I'm trying to achieve.

       

       

      Also, the last five weeks of the current year vs the last five weeks of the previous year variance for the last 3 years.

       

      - Weekday is the same when comparing current vs Previous years

       

      - Day fall on the same for year on year comparison 52 weeks

       

       

      e,g 13/05/2018

             14/05/2017

             15/05/2016

       

       

      Thanks

       

       

      Regards

      Tony