see the attached
is this what you expected
I added a rank function
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thank you Jim. I have been encountering this sorting issue sometimes. Could you please explain why the default sorting by Sum of Rev does not work?