Computer Tutoring Logo
Est. 2002
Menu Button

Sorting 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.
    Pivot Table sort 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.

Sorting Pivot Tables - exercise file.