I have a pivot table with Rep, Manager, Sales, and Goal. I created a calculated field to show the Sales / Goal called Sales %.
I want to now show the rank of each rep across the entire set of reps.
Excel keeps wanting to show me the rank within each Manager regardless of me telling the rank function to use "Rep" as the base field.
The only way I can get it to work is to remove the Manager field. But I want to be able to show Manager as well as it is important information to display.
Here is an example...
https://docs.google.com/file/d/0B8xHGgpo0DJOM3dIT2xZTUhWY0U/edit?usp=sharing
I want to now show the rank of each rep across the entire set of reps.
Excel keeps wanting to show me the rank within each Manager regardless of me telling the rank function to use "Rep" as the base field.
The only way I can get it to work is to remove the Manager field. But I want to be able to show Manager as well as it is important information to display.
Here is an example...
https://docs.google.com/file/d/0B8xHGgpo0DJOM3dIT2xZTUhWY0U/edit?usp=sharing