1 2 Previous Next 19 Replies Latest reply on Jan 6, 2018 12:01 AM by Drony Sharma

    How to calculate % change between q4(quarter) of year 2016 and q4 of 2017 ?

    Drony Sharma

      Hi Everyone.

       

      Wish you all a very Happy New Year 2018!

       

      Please help me to solve this question. I need to calculate the %change, difference between quarter 4 of 2016 and quarter 4 of 2017 . As shown below, I have Sum(Sales) for different peer groups for last 5 quarters. I need to calculate the %change in sales between  2017 q4 and 2016 q4.

       

         

      Peer GroupDate
      2016 Q42017 Q12017 Q22017 Q32017 Q4%change (2017 Q4 - 2016 Q4)
      A1245134526
      B3467154297
      C5689929321
      D7820353468

       

      Thanks for your time.

        1 2 Previous Next