For example, you might want to sort products by total sales, with the best-selling products listed first.
This is easily done.
Lets take a look.
Lets quickly build a pivot table that shows total sales and order count by product.
As usual, products are listed in alphabetical order by default.
We can do the same thing with Orders.
Lets sort orders in descending order.
As always, we can hover over the sort icon to see the currently applied sort options.
Lets remove Sales, and add City as a column label.
Just select a City, and smack the Sort button.
In this case, we want to sort in descending order, by Orders.
Note that the title of this dialog box shows that we are sorting the City field.
When we click OK, the cities with the most orders are at the left.
Products are still sorted by Orders as well, with greater values at the top.
Both options take you to the same place.
you might also sort by value at more than one level.
Lets sort Category to match Product.
For example, we can select a Category subtotal, and sort only by Category.
And we can do the same thing with Product.
