Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
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.
Try
Aggr(Count( Distinct customer), Item)
=COUNT({<Item = P(Item)>}DISTINCT customer)
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.
=Count(DISTINCT {<customer=P(customer)>-<customer=P({<Item=E(Item)>})>}customer)