Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
i want to find out the Salesperson who made the sales in multiple country.
my table
Maybe like
Sum({<SalesPerson1 = {"=Count(DISTINCT CustomerCountry)>1"}>} salesss)
Maybe like
Sum({<SalesPerson1 = {"=Count(DISTINCT CustomerCountry)>1"}>} salesss)
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 .
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)
Thanks Stefan