How to bind a value that repeat more than once to a list box

[#1]

I have a table with two columns salpersonid & productid

I want to bind the Salespersonid to a list box who sold more than one unique product.

When Check the show frequency checkbox it shows the all salepersonids who sold at least one product, But i want to see the salesperson ids who sell more than one unique product at least.

[Gysbert_Wassenaar]

Try using this expression for the listbox:

aggr(only({<Salespersonid={'=count(distinct Productid)>1'}>}Salespersonid),Salespersonid)

note: replace Productid with the field name of your product dimension.

[#3]

You can create a list box expression like:

if(count(Distinct ProductId)>1,SalesPersonID)