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:
Brand
Customer
Total
905
Bison
Retail
235
Bison
Philips
202
Bison
Organised Deal
155
Bison
Not Organised Deal
170
Altrex
Retail
55
Altrex
Philips
35
Altrex
Dos Pinos
25
AXA
Retail
16
AXA
Philips
12
What I want to see is this:
Brand
Customer
Total
555
Bison
Retail
235
Bison
Philips
202
Altrex
Retail
55
Altrex
Philips
35
AXA
Retail
16
AXA
Philips
12
I think I need to use set analysis, but I just can't figure out how. Thank you in advance.