I have a request from a user to create a report by sales associate ranking each sales associates top100 customers. I can have multiple sales associates on the request. For example I am a VP and I want to know by sales associate each of their top100 customers. How can I do this using the rank function?
