1 Reply Latest reply on Jan 13, 2019 10:13 PM by Shinichiro Murakami

    WoW Change of rolling L7 days

    Puja Doona

      We're working an agency that provides us data like below and our week starts Monday. The yellow highlighted cell is the actual WoW number that we want the management to look at as it represents the WoW over the previous /rolling 7 days. So 31 dec - 6 jan - the change in sale share was -3% WoW.



      Ultimately, we want to show the data like below that shows the actual WoW change for the completed week:



      Not sure how to go about it. File attached.