2 Replies Latest reply on Mar 22, 2018 7:36 AM by Patrick Weber

    Exclude the whole record if one child record has a special tag

    Patrick Weber

      Hi Tableau friends,

      I have a master table where you'll find customers and a child table for contacts.

      Some contacts got a tag which is called invoice.

      My aim is to filter  and exclude the whole record if only one of those contacts who belong to the customer has an invoice tag.

       

      E.g: CustNo 2005: One contact already has the invoice tag how I can exclude the whole record so that I'll only see customers who don't have any invoice tag (custNo: 2000, 2001, 2002, 2007, 2008 and 2009).

      I already tried to use just Tag as a filter bt if I exclude "invoice" the result is incorrec.

       

      See my attached workbook.

       

      Thanks for any advice.