11 Replies Latest reply on Jul 27, 2018 6:13 AM by Zhouyi Zhang

    WoW KPI change%: how to remove prev. week change %?

    ABRAHAM PETER

      Hi,

       

      I am trying to find out the WoW KPI difference between last 2 weeks through colour coding and trend arrows.
      The % difference was found out using Quick table calculation- percentage difference.


      However I face the below issues.

      1. Unable to hide previous week KPI difference(Week 29 in the below snapshot). I require the % difference between Week30 and 29 only.

      2. % diff for city: Chicago appears to be wrong as 631% instead of correct figure: 628%

       

      Seems like i have followed a wrong approach. Requesting help to sort this out. Thanks.
      Superstore sample workbook attached herewith (V 2018.1.2)

       

      Regards

      Abraham