3 Replies Latest reply: Aug 20, 2015 9:56 AM by Sundarakumar Kalaimani RSS

    Create new variable using same columns

      I have my data set like this


      VendorQuarterCurrent quarter
      MarketQ3 2013100
      MarketQ2 2013200
      MarketQ1 2013300
      MarketQ4 2013100
      MarketQ3 2013200
      MarketQ2 2013300
      MarketQ1 2013100
      MarketQ4 2013200

      I want new variable "Growth" so that  , growth of Q4 will be calculated from Current quater. and like wise for other quaters as well..

      for ex. growth= q4/q3-1