6 Replies Latest reply: Dec 14, 2017 7:11 AM by Sunny Talwar RSS

    Problem in calculating Growth by Month-Year(This year month vs Pre Year Month)

    Rohit Kumar

      Hi Techies,

       

      I am facing a problem while calculating growth% by Month-Year in Table chart. The result I am expecting is :

       

      Month-Year  KPI Growth%

      Jul-2017       A      10%(Val of Jul-2017 / Val of Jul-2016 -1)

      Jul-2017       B      20%

      Jul-2017       C      30%

      Aug-2017     A      10%

      Aug-2017     B      20%

      Aug-2017     C      30%


      Formula I am considerng is : July 2017 Sales/July 2016 -1


      Please let me know how to do it


      Thanks in advance

      Best,

      Rohit