4 Replies Latest reply: Oct 10, 2012 10:56 AM by 872653 RSS

    Second row data -  First row data of other column?

    872653
      Hi All,

      I have a requirement to show the second row data of the column1 as first row in column2. Please see the example below, where month is filtered <= 05.
      Month    Sales    Sales_New
      01         500      600
      02         600      700
      03         700      800
      04         800      900
      05         900      NULL
      In the above example for month 05, column Sales_New should show NULL because it is the last row of the query.

      Thanks in advance.