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 resultIexpected
if i chose PRODUCT = D, the result count customer = 2 (Peter and lisa), because Peter and lisa buy only product 'D' (KenalsobuyD productbutalsoboughtA andBshouldnot be counted)
if i chose Product =A and B, the result count customer = 1 (John) because Johnjustbuytwo productsA andB (Tonyalsobought one moreproduct 'D'shouldnot be counted)