Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All
I want to count only customer buy selected products
Here my sample dada
CUS_NAME | PRODUCT |
---|---|
John | A |
John | B |
Peter | D |
Ken | A |
Ken | C |
Ken | D |
Tony | A |
Tony | B |
Tony | C |
Mary | B |
Lisa | D |
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