13 Replies Latest reply on Jul 16, 2018 11:55 PM by Mavis Liu

    Last five weeks of the current period for 2018 and values for the same period in 2017

    Tony Smith

      Hi All,

       

      Can someone please help me with the  request below.

       

      1) Create a report that will display values for the last five weeks of the current period for 2018 and values for the same period in 2017

       

      2) Using the values from above, display the YoY.  Divide the value for a specified 2018 week with the value for the same week in 2017 minus 1

      e.g

      (week 26 of the current year/week 26 of the previous year) -1

       

      (week 25 of the current year/week 25 of the previous year) -1

       

      (week 24 of the current year/week 24 of the previous year) -1

       

      Thanks

       

      Regards

      Tony