Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Isn't this what you want?
Attaching the sample for you to play around with
Best,
Sunny
May be like this:
1) Concat({<Cust_ID = P({<product = p(product)>})>} Customers, ', ')
2) Concat({<Cust_ID = E({<product = p(product)>}), product>} Customers, ', ')
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.
Isn't this what you want?
Attaching the sample for you to play around with
Best,
Sunny
Thanks a lot