1 Reply Latest reply on Feb 19, 2014 8:23 AM by Matt Lutton

    How to create filter with AND criteria instead of OR criteria

    Alay Patel

      Create filter with AND criteria instead of OR criteria

       

      I need to create a filter that shows the number of users who have used multiple products.

       

      However, I need to display the number of users who have both products instead of any of the products.

       

      For example, I have listed three products below:

       

      1. Product Apple

      2. Product Banana

      3. Product Orange

       

      I was able to create a filter (which is the Tableau default) which tells me how much users have used any of the products in between Product Apple, Product Banana, and Product orange.

       

      However, in addition, I need to know how many users used both Product Apple and Product Banana, or Product Orange and Product Apple (etc. etc.)