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



      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




      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!