I have a large data file, I did sales $ report in a pivot table by custmer.
Is it a way to sort custmer by their sales $?

Sales $ is in data area, customer is in row area, we want to sort it like
the report on right side below.

Customer Sales Customer Sales
A 1000 C 20
B 5000 A 1000
C 20 B 5000
6020 6020