Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I want to present a list that contain customer names of all customers that didn't bought specific product.
for example:
Customer_Name | Product_1 | Product_2 | Product_2 |
---|---|---|---|
Name_1 | 1 | - | 0 |
Name_2 | 1 | 1 | 1 |
Name_3 | - | - | 1 |
I want to have a list box that contains all the available products and by selecting one product in the list box I will get list/table of all the customers that didn't bought the selected product.
so if I select product_2 I will get Customers: Name_1 and Name_2.
I tried to use the e(Product_Name) function but it didn't work for me because once the customer bought different product and didn't bought the selected one he appears in the chart.
Any idea how I can deal with this issue?
Thanks a lot
Assuming you have one field named Product_Name and not three fields named Product_1, Product_2 and Product_3...
Create a straight table with Customer_Name as dimension and this expression: sum({<Product_Name=,Customer_Name=E({<Product_Name=P(Product_Name)>}Customer_Name)>}1)
Assuming you have one field named Product_Name and not three fields named Product_1, Product_2 and Product_3...
Create a straight table with Customer_Name as dimension and this expression: sum({<Product_Name=,Customer_Name=E({<Product_Name=P(Product_Name)>}Customer_Name)>}1)
Hi gwassenaar
Thank you it's work perfect!