Filtering dimension based on another field

[#1]

I don't know if i have phrased my question correct or not. here are the details

I have a data set which gives the sales by salesperson for a product and the customer who buys it

another data set which gives all the customers by salesperson

what i am trying to do is when a product is selected in the listbox, i want to display 2 lists

1. Customers buying that product

2. Customers not buying that product

1st one is simple, but i cannot figure out a way to do the second. please help.

[sunny_talwar]

May be like this:

1) Concat({<Cust_ID = P({<product = p(product)>})>} Customers, ', ')

2) Concat({<Cust_ID = E({<product = p(product)>}), product>} Customers, ', ')

[#3]

Could you elaborate.

i have added the screenshot of the scenario just to be clear.

please note that data set 1 only gets the customers where sales have been made, whereas data set 2 has all the customers.

[sunny_talwar · Accepted solution]

Isn't this what you want?

Attaching the sample for you to play around with

Best,

Sunny

[#5]

Thanks a lot