Karen: I sent your question off to an MBA friend of mine who, I hope, will have some insight into ranking sales performance. It's not so much a statistics expert as a business expert you're looking for.
In the meantime, I might do something like this: Assign each salesperson a rank from 1 to X (where X is the number of salespeople) according to total dollar profit. Assign them a separate rank according to percentage profit. Add the two ranks together, and print your list in ascending order of combined rank. You may have ties, in which case resolve them in favor of which of the two ranks you consider most important. People near the top of both lists will be on the top of your ranking, people at the top of one list but in the bottom of the other will be in the middle, and people at the bottom of both lists will be at the end. -- Larry ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
