3 Replies Latest reply: Feb 17, 2012 12:32 PM by Henry Noh RSS

    How show top ranked salesperson within each client in straight table

    Henry Noh

      Hello,

       

      I have a dataset that looks like this

       

      Clients   Salespeople   Sales($)

       

       

      I'd like to have a straight table chart that shows for all Clients:

       

      Clients        Top Salesperson's Name for that Client         Top Salesperson's Sales with that Client

       

       

      fyi,

      I've been working with the expression:

       

      =sum({$< Salesperson={"=rank(sum(Sales),4,1)=1"}>}  Sales)

       

      but this only gives the Name and Sales for the top Salesperson across all clients, not per client.

       

      Any help much appreciated.

       

      Thank you!