1 Reply Latest reply: Mar 14, 2017 12:54 AM by An Pham RSS

    Only Count Customer buy selected products

    An Pham

      Dear All

      I want to count only customer buy selected products

      Here my sample dada

      CUS_NAMEPRODUCT
      JohnA
      JohnB
      PeterD
      KenA
      KenC
      KenD
      TonyA
      TonyB
      TonyC
      MaryB
      LisaD

       

      here is result I expected

      if i chose PRODUCT = D, the result count customer = 2 (Peter and lisa), because Peter and lisa buy only product 'D' (Ken also buy D product but also bought A and B should not be counted)

      if i chose Product =A and B, the result count customer = 1 (John) because John just buy two products A and B (Tony also bought one more product 'D' should not be counted)


      I don't know how to do, please help me if possible

      regards

      An Pham