Pivot Table Sorting

Joined
Feb 8, 2002
Messages
3,014
Office Version
  1. 365
Platform
  1. Windows
When I create a pivot table with customers down the side, they are always sorted alphabetically.

How can I make it sort by revenue? (Descending)
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,014
Hi Bill,

Assuming revenue is a data field? Double click the top of the Column Field (A3?) and click the Advanced... button and then change the Using Field setting in the dropdown at the bottom left of the AutoSort options settings.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,118,755
Messages
5,574,044
Members
412,565
Latest member
roberttaekim
Top