6 Replies Latest reply: Jan 24, 2011 4:43 AM by Bhushan Nirgude RSS

    Top Ranked Salesperson's Name Next to Client

    Henry Noh

      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!