Find item that exist in BOTH category else display none

tableaucommunity@tableau.com — Fri, 13 Dec 2013 17:48:18 GMT

Hi,

I am trying to find a taskID that exists in both category and not just one.

So lets say in the following example, task ID 389042 exist in both Relevant but other and Not Relevant.

I have used "Contains" to put as quick filter but that shows all entries and not those that I can find with an "AND"

So what I am trying to achieve is, "which items exist both in the 'Relevant but Other' as well as 'Not Relevant / Skip' and it should show me

389042

389043

389044

Thanks a lot.

I have added the dummy data in excel file as well.

Content in Tableau Community Forums