auto sort table base on maximum sale of each customer and orders of customer consecutive

Hi,
I want to autosort table base on maximum sale of each customer and orders of each customer sort in desending order.
for example, table 1 autosort to table 2.
I can autosort base on maximum sale(table 1 autosoted) but no table 2.

please help.
thanks

autosort.xlsxautosort.xlsx