4 Replies Latest reply: May 23, 2012 11:46 AM by Julian A. Ortiz Villada RSS

    How to pass value in rows to another column

    Julian A. Ortiz Villada

      Hi, i have this data

       

       

      Month
      Value

      201205

      200
      201204100
      20120350
      201202100

       

      I want manipulate the data and pass to one row, like this

       

       

      Month
      Current
      Month-1
      Month-2
      20120520010050
      20120410050100
      201203501000

       

      The idea is have the current value and the last 4 months.

       

      ¿Any suggestions?

       

      Thanks in advance

       

      Julian