5 Replies Latest reply on Mar 4, 2018 7:30 PM by Zhouyi Zhang

    YOY comparison with shifted weeks

    Mike Rossi

      Hi guys,

       

      I am trying to create a YOY comparison with shifted weeks. That means that the every week of the current year will be compared with the next week of the previous year. To give an example:

      • Week 1 2018 will be compared with Week 2 2017
      • Week 2 2018 will be compared with Week 3 2017
      • Week 3 2018 will be compared with Week 4 2017

       

      I managed to create a YOY calculation but that compares only equal weeks. For example Week 1 2018 with Week 1 2017. Do you have any ideas how we can create the shifted comparison?

       

      Workbook attached. Thank you!