Pivot Table Column Sorting

[Jensen 3:16]

I have a pivot table of most frequented destination spots by age and sex and amount spent at each destination. It seems the pivot table is ranked in an alphabetical order and I was wondering if there is a way to rank the table by column D instead? Ex: have it rank in descending order based on $ so NY would show first in the column followed by Paris. Any guidance would be greatly appreciated, Thank You.

A B C D
A1 Amount Spent
A2 Row Labels F M Grand Total
A3 25-34
Cancun $578.17 $1,204.33 $953.87
London $549.80 $1,174.50 $890.55
New York $601.00 $1,244.14 $1,029.76
Paris $611.27 $1,237.18 $961.78
Philadelphia $586.57 $1,198.27 $960.39
San Juan $571.35 $1,213.71 $861.45
St Thomas $579.45 $1,229.38 $918.54
Sydney $594.40 $1,230.00 $941.09

 

[Robert Mika]

Try this:
Right Click on Pivot table on your City column--> Sort--More Sort Options--Descending Z-A (choose column on which you want to sort)