Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Top 3 Salesmen by total Sales

Status
Not open for further replies.

cwhicks

Programmer
Mar 30, 2006
1
US
This is probably simple for everyone, but how do I show a list of the top 3 of a summary total? I would need to total a list of sales the salesmen had made through out the year, and then sort it by that total, and then limit it to only 3 of the salesmen. Example would be:

Bob $10,453,234
Mary $5,324,239
Steve $4,342,978

Thanks
 
Data Item1: total([Sales] FOR [Salesman])
filter: rank([Data Item1]) <= 3
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top