3 Replies Latest reply on Aug 20, 2018 7:51 AM by vidhya srinivasan

    Get specific rows based on conditions in tableau work sheet

    vidhya srinivasan

      I have  a custom SQL from which I created a worksheet in Tableau like this:

       

      Col 1Col2Col3
      123Taylor8
      456Chris1
      Christina1
      789Smith5
      649Alexa3
      Eliza2

                                          

      Col 1Col2Col3
      123Taylor8
      456Chris1
      Christina1
      789Smith5
      649Alexa3
      Eliza2

       

      Col 1 is unique . I want to select the rows that have two or more values of Col 2 for a single col 1 value. Example : i want to select the entire row where col 1 = 456 and 649 . I want to display only rows satisfying this condition. can you please assist me with the formula i should be looknig for? Let me know if i have to be more elaborate.