7 Replies Latest reply on Jan 16, 2017 4:04 PM by Frantisek Trenkler

    Filter as AND instead of OR

    Frantisek Trenkler

      Hello

       

      I have a list of unique calls and call categories. Each call can fall into multiple categories. Each instance of call/category has its own row in the data source.

       

       

      Right now, as an example, when I filter to "Billing" and "Competition" categories, Tableau will show all calls that fall within "Billing" OR "Competition" category.

       

      What I am trying to do, is to be able to only show calls that fall in ALL of the filtered categories. So in this screenshot, I would only want to see calls 20620327 and 20620357, because only those are in both "Billing" AND "Competition".

       

      Any ideas? BTW I cannot pivot the data as my data source is SQL.