1 Reply Latest reply on Feb 13, 2019 4:49 AM by Jim Dehner

    Filter unique ID to find out behaviour such as ONLY like 1 colour but not the others...

    cataline.wen

      hi seasoned Tableau users.

       

      I have a question but don't the the right jargons to ask the correct questions.

       

      The scenario is:

       

      I have some users bought all different coloured pen and some users bought 2 different coloured pen, and some users bought 3 different coloured pen.

       

      How to find out

      1. count the unique User who only bought RED, but not the others

      2. count the unique user who bought RED, but may be also bought BLUE

       

      etc etc

       

      Many thanks if you can show be the right way to approach this.

       

      Thank you in advance.