Pivot Table Sorting

Joined
Feb 8, 2002
Messages
2,997
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

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.

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,114,037
Messages
5,545,665
Members
410,697
Latest member
srishtijain0708
Top