Excel Tutorial on Sorting Data In Pivot Tables

Sorting data or values within a Pivot Table is pretty straightforward, if you know how. Here's how you do it. If you want to follow along with this you can download the sort pivot table exercise file.

1. Create a Pivot Table and Add the field you need.
2. Click on the Row Labels Drop down menu.
   
3. Choose the field that you want to sort by. (If you are following along with the exercise file choose Country).
4. From the same menu choose More Sort Options.
5. In the Sort (Country) dialogue box choose the Descending radio button, then choose the value you want to sort by. (As you can see from below I choose Sum of Total Inc. Vat).
   
6. Click OK and view your results.

Pivot Tables for beginners tutorial.

Build your Excel skills further: Want to develop these skills with an instructor? View our Microsoft Excel training courses for live online, onsite and tailored Excel training.