5 Replies Latest reply on Apr 6, 2018 4:36 AM by Jim Dehner

    Tricky formula needed

    Aniruddha Dhamne

      I have a table in below format and want a new column added which will give status for project where id = 1 and it should reflect in all rows with the same project name.

      I tried with fixed...

      {FIXED [Project Name]: MIN([Status])} but that gives only accurate answer for project ABC not sure how to handle the other 2 scenarios where ID =1 is the last row for that particular project and if status is NULL then it takes the next status within that project.

      Thank you in advance to all the awesome Tableau enthusiasts!!!

       

      Input :

       

      Output: