How to sort repeating group by two variables simultaneously?

Hi,
Lets say I have a database with clients, their balance and their account manager
How do I, using one repeating group, sort the clients by last name of the account manager and within this sort by balance of the client?
e.g.
account manager Xs client with 10k then 1k then 500 then account manager y’s client with 9k then their client with 8k then 7k etc.
I do not want to use 1 repeating group in another; just 1; is this possible?