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

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,

• ###### 1. Re: Looking up previous values for unique rows, if one is false all are false

Hi, Ahmed

Please find my solution attached as well as below screenshot of the calculation

Hope this helps

ZZ

1 of 1 people found this helpful
• ###### 2. Re: Looking up previous values for unique rows, if one is false all are false

Works brilliantly.

Thank you very much for your efforts, Zhouyi.

• ###### 3. Re: Looking up previous values for unique rows, if one is false all are false

No worries,  I am glad to help

ZZ