Customize a pivot table

You can change how your pivot table data is listed, sorted, summarized, or filtered.

Order and sort columns or rows

You can sort and order your data by pivot table row or column names or aggregated values.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the pivot table.
  3. Under "Rows" or "Columns," click the arrow under "Order" or "Sort by."

Note: To show the totals of a row or column, check Show totals.

Change how your pivot table looks

Change header name

To change the header of a column:

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the pivot table.
  3. Click the name of a row or column and enter a new name.

Note: You can’t rename "Grand Total."

Show a value as a percentage

You can show a value (like October sales) as a percentage of a whole (like annual sales).

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the pivot table.
  3. Under "Values," under "Show as," click Default.
  4. Choose an option from the menu.
Group data together

You can choose a set of values in a pivot table and group them together manually or with a rule.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the pivot table.
  3. To manually group:
    1. Select the cells you want to group together.
    2. Right-click the cells, then click Create pivot group.
  4. To group rows together by a rule: 
    1. Right-click a cell, then click Create pivot group rule.
    2. For numbers, choose an interval size. Optional: Choose when your groups start and end.
    3. When you are done, click OK.
  5. To group rows together by date or time: 
    1. Right-click a cell with date formatted data, then click Create pivot date group.
    2. Choose a date or time period to group by.
  6. Optional: To ungroup, right-click a grouped item, then click Ungroup pivot items.

Filter out data in a pivot table

You can hide data that you don’t want to show in your table.

  1. On your computer, open a spreadsheet in Google Sheets.
  2. Click the pivot table.
  3. Next to "Filters," click Add.
  4. Choose a value.
  5. Under "Show," click the arrow, then uncheck the items you want to hide from the pivot table.

Note: If you're using a filter, then update your data, new data won't show in your pivot table.

Related articles

Andrew is a Docs and Sheets expert and author of this help page. Leave him feedback below about the page.

Was this article helpful?
How can we improve it?