Last Updated on November 1, 2023 by Jake Sheridan
In this tutorial, you will learn how to sort pivot tables in Google Sheets.
How To Sort Pivot Tables in Google Sheets
Google Sheets offers a powerful and convenient way to analyze large data sets through the use of pivot tables.
Users can take advantage of pivot tables to organize and summarize large amounts of data with a simple interface.
You can use a pivot table to sort your data in a variety of ways using the Pivot table editor. Google Sheets even allows you to sort by multiple fields and sort by summarized values.
This guide will tell you everything you need to know to sort a pivot table in Google Sheets.
How to Sort a Pivot Table in Ascending or Descending Order in Google Sheets
Here’s how to sort a pivot table in ascending or descending order in Google Sheets.
Select the pivot table you would like to sort. You should now see the Pivot table editor on the right of your screen. In the Rows section, expand the Order drop-down list.
You can now select whether to sort your pivot table data in ascending or descending order.
In this example, we will sort our pivot table by country name in descending order.
After selecting your preferred sort arrangement, your pivot table should now update automatically.
We can also change the field to sort by. Expand the drop-down list below the ‘Sort by’ label to browse other options.
The drop-down list will also display values you’ve set for the current pivot table.
In this example, we were able to order our pivot table by the Total Quantity field.
Google Sheets allows you to sort your pivot table using multiple sort fields. In the example below, we have two row fields to sort by. The data will be sorted first by country, followed by color.
If you would like to change the sort order, simply drag the row elements in the Pivot table editor to match your preferred priority. The top-most field will be the primary sort for your data.
Using multiple sorts is useful when you’re summarizing rows that use two or more rows.
Pivot tables allowed us to sort our data by country alphabetically and also sort the T-shirt color sales for each country in descending order by quantity of sales.
This guide should be everything you need to sort a pivot table in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.