2 Replies Latest reply: Nov 17, 2012 8:29 AM by Przemysław Wojda RSS

    Multinested previous()?

    Przemysław Wojda

      Hi All,


      I've got a dataset with 2 columns where some records miss value in the first column. In these very records where values are missed I want to assign last value in the first column as shown below. I guess prevoius() will not work here. Do you have an idea how to solve it?






      Name, City 
      John, Berlin
      Mary, London
      , Paris
      , Amsterdam
      Name, City
      John, Berlin
      Mary, London
      Mary, Paris
      Mary, Amsterdam