5 Replies Latest reply on Nov 10, 2016 5:01 AM by John Croft

    Filter a dimension by another dimension

    Magdalena Słoma

      I have a list of customers who buy different product categories, such as network, service, labels etc. There are customers who buy only within the same category, and there are also those who buy in many categories. It seems like this:

       

      Client               Category

      A                    network

      A                    service

      A                    labels

      B                    service

      C                    network

      D                    labels

      E                    service

      E                    labels

       

      How can I filter out those customers who don't buy anything from the network?

      So I want to show only clients: B, D, E.

       

      Thanks for the help ,

       

      Magda