This content has been marked as final. Show 6 replies
I have a chart with Clients on the left side.
Each client deals with multiple salespeople.
I'd like to create a straight table with CLIENTS on the left and a column with the #1 RANKED SALESPERSON for that client (the name as well as the sales amount).
I think this is possible using the aggr(rank( function, but can't get the syntax exactly right.
Any help much appreciated. Thanks in advance!