I'm having an issue with displaying the top 20 names in the list. The names should be sorted based on the total requests count and if the request count is same, sort the names using the last name in ascending order. The issue is the last 2 names are wrong in the list in the attached workbook. How do I sort the names using their last name when the counts are same ?
Is the chart on the right what you are looking to get?
But it is not just the last two which changed... there were few others which changed as well and that's just because based on your current selections, there are few of the names where total request were the same and the sort order was not ascending by last name.... for example
Last name Kim and Bowman both have total request of 19, but they are currently sorted in descending order of there last names (assuming Kim and Bowman are the last names here)
Thanks Sunny! The list I have originally was for Top 22. If you change it to Top 20 under the 'Dimension Limits", the list changes again. How do we keep the names sorting consistent when changing the top N value ?