3 Replies Latest reply on Jan 6, 2014 2:25 PM by Harold Hovagimian

    Help with Parent/Child Relationship in Data Please

    Harold Hovagimian

      I have a table of Non conformances (NCs) that lists Parent_NC and NC Number. Children know they have parents, but parents do not know they have children. I am trying to use a calculated field to display the top level parents only. Thus far I've been able to have a true statement that shows 'True' if it is the top level, but tried using CONTAINS and LOOKUP to try and display the top level parent NC, and I'm just running around in circles. I've uploaded a picture of what it looks like and what I am trying to achieve.

       

      Tableau Help.png

       

      I cannot upload the data.