1 Reply Latest reply on Oct 27, 2016 2:42 PM by Patrick A Van Der Hyde

    help creating a new column  with previous() logic

    archana.chandra

      hi ,

       

      I'm trying to  stores all previous values for a user in new Calculated field.

       

         

      user idPlanExpected OutPut
      1A
      1AA
      1BA
      1BB
      1CB
      1DC
      1ED
      1FE

       

       

      expression I am writing is its throwing me an error..

       

        if [User_id]= LOOKUP(max([User_id),-1)

      then LOOKUP(max([Plan]),-1)

      end

       

       

       

       

      I'm new to tableau . so facing lot of difficulty writing expressions. any help will be appreciated.