I have 20 salesmen, each with different quotas and start dates. For example
Guy A has $424 in and shows 57% since his quota is 783 YTD. But Guy B has
$18 in and shows 115% since his YTD quota is $16...he started a month ago.
So when I rank..obviously Guy B ranks 1. For YTD sales, I need a formula to
rank them 1-20..based on the differences in their quotas. Can this be done?
Thaks