0 Replies Latest reply: Aug 11, 2014 8:12 AM by Maurits Groenendijk RSS

    Show only customers who purchased all selected values (brands)

      Hello,

       

      Hope someone can help me. What I want is this: to get a list of customers who purchased all selected Brands. Now, when I select three brands like Bison, Altrex and AXA I get all customers which purchased one or more brands, See below:

       

      BrandCustomer
      Total 905
      BisonRetail235
      BisonPhilips202
      BisonOrganised Deal155
      BisonNot Organised Deal170
      AltrexRetail55
      AltrexPhilips35
      AltrexDos Pinos25
      AXARetail16
      AXAPhilips12

       

       

      What I want to see is this:


      BrandCustomer
      Total 555
      BisonRetail235
      BisonPhilips202
      AltrexRetail55
      AltrexPhilips35
      AXARetail16
      AXAPhilips12

       


      I think I need to use set analysis, but I just can't figure out how. Thank you in advance.