How to arrange in ascending order all subtotals

Dear All,

I have a sales commission file , where there are columns of invoices number , date , amount of invoices , sales executive code .

the problem is each invoice would be for one sales executive only and not for any other sales executive .

but in my invoice number (12345) is appearing for eg: in sales executive code( 4 ) also and (10) also .

there are many case like this . i want to sort out how can i find out that all invoices will be in there sales executive code only .