Summarising a sales table - 1st, 2nd, 3rd salesperson?

[BrianJ]

@rodwhiteley,

“I don’t know if this is going to be a useful technique for others, but would there be a way to resolve ties by a second criteria perhaps?”

Wow, you were really prescient on this one. Look what question popped up today:

Ranking Equal Values based on alternative parameters

@Anferrig, Here’s how I do this: do a RANKX of your secondary criteria first, but make sure you ASC as the sort order, so the best performer gets the highest rank, not a rank of 1 CONCATENATE your primary metric (in this case points) with the result of the reverse RANKX above using “.” as your delimiter. For example, Juventus would get a value of 90.20 (90 goals, and the 20th reverse ranking in 1). Be sure to wrap your CONCATENATE statement in a VALUE() function so that it returns a …

• Brian