3 Replies Latest reply on Nov 29, 2018 2:39 PM by Zhouyi Zhang

    Looking up previous values for unique rows, if one is false all are false

    ahmed.abul

      Dear Tableau Gurus,

       

      Apologies for the unclear title as I do not know exactly how to phrase this question. My data set looks like this

       

      ID         T/F            Calculation

      111        True         False

      111        True         False

      111        True         False

      111        False       False

      222        True        True

      222        True        True

      222        True        True

      333        False      False

      333        False      False

      333        False      False

      333        False      False

       

      So as you can see above I want to create a calculation that checks if one of the values for an ID is false, all of them become false as well. So we have 4 lines for the same ID, but one of the lines for this specific ID is false. Therefore all of them must be false as well.

       

      But if all the lines for the order are true, it will return all true.

       

      Your help on this matter is much appreciated.

       

      Thanks,