Count customer that only buy one product

[#1]

HI. I have a listbox with items that customer have bought. How can I count how many people that have only bought the selected product in following example?And nothing else.

customer.     Item

a.                  Shirt

a.                  Shoes

b.                  Shoes

c.                   Shirt

d.                  gloves

d.                  Shoes 

e                   Gloves

expected result.

If I selected Shirt, number of customer = 1 (cust c)

select gloves, number of customer = 1 (cust e)

[jduenyas]

Try

Aggr(Count( Distinct customer), Item)

[MK_QSL]

=COUNT({<Item = P(Item)>}DISTINCT customer)

[jagan · Accepted solution]

Hi,

Try like this

Chart : Straight Table

Dimension: Customer

Expression: Sum({<Item =P(Item)>} Aggr(If(Count({<Item =>}DISTINCT Item) = 1, 1, 0), customer))

Hope this helps you.

Regards,

Jagan.

[anbu1984]

=Count(DISTINCT {<customer=P(customer)>-<customer=P({<Item=E(Item)>})>}customer)