1 Reply Latest reply on Jul 13, 2016 3:28 AM by khalid norat

    Tableau 1 to Many Condition/Filter

    Nader H

      Hey community,

       

      Been struggling for a while to find a Boolean condition to filter out the following scenario:

       

      Tableau 1 to many.png

       

      If Customer Name has registration year = 2014 and 2015 then return rows

       

      Tableau 1 to many (2).png

       

       

      If customer Name has registration year = 2014 but couldn't find a matching record in 2015 then return rows

       

      Test3   |   2014

       

       

      The thing is customer name/ID needs to be taken into consideration as i need to verify if the policy was renewed by the Customer and identify which policies were not renewed. I'll be dealing with 100,000+ rows so hope that gives an idea

       

       

       

       

      Thanks in advance!