How show top ranked salesperson within each client in straight table

[#1]

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!

[deepakk · Accepted solution]

hi,

try the attach application

Deepak

[swuehl]

This should be quite straight forward in QV11, using the dimension limits in straight table properties.

Create a chart with the two dimensions Clients and Salespeople and as expression sum(Sales).

Then enable 'Restrict which values are displayed..' in dimension limits tab for the second dimension Salespeople and select Largest 1 value.

Hope this helps,

Stefan

[#4]

Thank  you!