3 Replies Latest reply on Aug 1, 2018 9:39 AM by Yasser Akhtar

    How to calculate percentage difference in same column but different row

    Yasser Akhtar

      I have table with Three categories in rows and weeks in columns

       

       

      CaegoryWeek 1Week 2
      Category A21%16%
      Category B18%15%
      Category C62%69%

       

      I would like to know how I can calculate "Category C" subtracted from "Category A" and have it be showin next to "Week 2" column?

       

      Thanks, I am a newbie.

       

      Yakhtar