5 Replies Latest reply: Jun 15, 2012 10:35 AM by Andrea Rebora RSS

Set Analysis: select data, exclude data

Andrea Rebora

Hello!

I have these data:

 

N°OrderProductProductPriceProduct Type
CustomerID
11111Pen1,00Supplies1
11111Rubber4,00Supplies1
22222Paper3,00Supplies2
33333Paper3,00Machine1
44444Bag15,00Machine3
55555Pencil2,00Supplies4
55555Pen1,00Supplies4

 

I would select only the customers whom have bought only "Product Type: Supplies" and never Machines.

In this case customer 2 and 4

 

I think it is possible with Set Analysis, but I don't know how.

 

Thanks