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