I try to sort the data area, but not the row area in a pivot table.

The sales report is pibot by custmer in sales $. Is there a way to sort the
customer by their sales $, not by letter? Such as the report in the right
side below.

Customer Sales Customer Sales
A $5,000 C $200
B $10,000 A $5,000
C $200 B $10,000
Total $15,200 Total $15,200