Top 20 sorting issue ?

[bob654321]

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 ?

[sunny_talwar]

Does this look right?

[bob654321]

No, below is the list the users are expecting to see.

[sunny_talwar]

Which period is HOCKENBERRY, LESTER M gets a 2 position for current position?

[bob654321]

The date filters selected are  year = 2018 and Quarter =  Q3, so the current position is based on those filters.

[sunny_talwar]

This is the list for 2018 Q2 where LIM-SEIWERTM TANGUY is ranked 20... why do you have it showing as 21?

My gives expression gives this... which seems to be very close to what you need Rank wise

[bob654321]

I think you have the header title in the first row which is why you are seeing that person as 21.

[sunny_talwar]

Right, but the actual rank is 20, correct?

But your screenshot says Prior period rank to be 21, why?

[bob654321]

Good question, I'll find out from the users.