4 Replies Latest reply: Feb 20, 2012 4:01 AM by Medea Linanda RSS

    [URGENT] How to know which customer buy 2 products together?

    Medea Linanda

      Hi,

       

      I have transaction table like this:

       

      CustomerProductsQty
      Cust AMCD1
      Cust AKFC3
      Cust BMCD6
      Cust CKFC7
      Cust DMCD9
      Cust EMCD2

       

      How to create a report to calculate number of customers by products?

      ProductsNo of Customers
      MCD3
      MCD & KFC1
      KFC1

       

      Thanks