Find out Salesperson who made sales in more then one country( Set Analysis)

[Santosh]

Hi

i want to find out the Salesperson who made the sales in multiple  country.

my table

[swuehl · Accepted solution]

Maybe like

Sum({<SalesPerson1 = {"=Count(DISTINCT CustomerCountry)>1"}>} salesss)

[Santosh]

Hi Stefan

I have one more question

supposes i have list of country and i want find the salesperson who made sales in Argentina and also in Austria .

[swuehl]

Maybe using p() function and intersection operator

=Sum(

{<SalesPerson1 = p({<CustomerCountry = {'Argentina'}>}) * p({<CustomerCountry = {'Austria'}>}) >}

salesss)

or using an expression search

Sum(

{<SalesPerson1 =

{" =Sum( {<CustomerCountry = {'Argentina'}>} salesss) > 0

and Sum({<CustomerCountry = {'Austria'}>}salesss) >0"}

>}

salesss)

[Santosh]

Thanks Stefan