Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),4),Salesperson)=1,Salesperson),' ')

FirstSortedValue{DISTINCT Salesperson,-Aggr{Sum(Sales),Salesperson))

Concat(DISTINCT IF{Aggr{Rank{Sum(Sales),1),Salesperson)=1, Salesperson) , ' ')

FirstSortedValue {Salesperson, -Aggr (Sum{Sales), Salesperson))

Open the data manager, split the Customers table, and Concatenate Orders and Customers on the CustomerlD field

Open the data manager split the Customers table, and associate on CustomerlD

Open the data load editor, use CONCATENATE to concatenate Orders and Customers

Open the data load editor, rename the CustomerlD field, and concatenate Orders and Customers

NullAsValue*; Set NullValues = 'Missing Value';

NullasNull *;

Set NullValues = 'Missing Value';

NullasNull *;

Set NullValue = 'Missing Value';

NullAsValue*;

Set NullValue = 'Missing Value';