![](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150B60D78F13600351D2/en_US/b41caff93c0da85fc0ca4a85751cc32d.png)
Change how pivot table data is sorted, grouped, and more in Numbers on Mac
You can change how the data in a pivot table is sorted, grouped, and calculated. You can also choose to repeat group labels, and show and hide totals.
Tip: If you want to change the style or formatting for certain types of data in your pivot table (for example, Total rows), you can quickly select all data of the same type. Click a cell you want to format, Control-click, then choose Select Similar Cells.
![The Pivot Options menu showing fields in the Columns, Rows, and Values sections, as well as controls to edit the fields and refresh the pivot table.](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150B60D78F13600351D2/en_US/9526a85ad7182aaa90f63e0d7a3bb74e.png)
Change how Column and Row fields are sorted
You can change the way groups in a field are sorted in a pivot table. For example, you can sort a group of students by their name in ascending order (A to Z), or sort the group by their average grade in the class in descending order (100, 99, 98…). You can also choose how to group dates, such as by year, year-month-day, or day of week.
Select a pivot table.
In the Pivot Options tab of the Organize
sidebar, click
next to the Column or Row field you want to edit, then do any of the following:
Choose how to sort groups: Click the first dropdown below "Sort Groups by," then choose an option.
Sort values in ascending or descending order: Click the second dropdown below "Sort Groups by," then choose Ascending or Descending.
Choose how to group dates: Click the dropdown below “Group by,” then choose an option.
Repeat Column or Row group names
You can choose whether you want to repeat the group name labels for Column or Row fields in each column or row in the pivot table.
When there are multiple fields in the Column or Row section, you can repeat group names for all fields in that section (except the last field listed in that section). When there are multiple fields in the Values section, you can also repeat group names for each column or row where values appear.
![A pivot chart showing Electric and Manual, the group names for the Power field, repeated in each row.](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150B60D78F13600351D2/en_US/1d686ce8820ff72c186780eec0e255c8.png)
Select a pivot table.
In the Pivot Options tab of the Organize
sidebar, click
next to the Column or Row field you want to repeat the labels for, select the checkbox next to Repeat Group Names.
Change how Value fields are displayed
Value fields use functions, such as sum or average, to summarize the data in a pivot table. You can choose from a list of functions, then change how the result is displayed. For example, you can calculate the sum of sales by an individual salesperson, then display the result as the percentage of total sales by the entire sales team.
Select a pivot table.
In the Pivot Options tab of the Organize
sidebar, click
next to the Value field you want to change, then do any of the following:
Choose a new function: Click the dropdown below “Summarize by,” then choose a function.
Change how the value is calculated: Click the dropdown below “Show as,” then choose an option. For example, you can show the result of the function as a percentage of the Grand Total, or as part of the Running Total for a Column or Row field.
If you choose Running Total In or % of Running Total In, you can choose which field is used to make that calculation.
If you have more than one Value field, you can also choose whether to show those fields as rows or columns. Click next to Values, then choose Show Values as Rows or Show Values as Columns.
Show or hide totals
When you add fields to a pivot table, Totals and Grand Totals are shown by default, but you can hide them.
![The More Field Options menu, showing the controls to hide grand totals, swap column and row fields, and clear fields.](https://help.apple.com/assets/65E6150B6FF3556065071CF8/65E6150B60D78F13600351D2/en_US/c611e7b76ae87f45c0922cbef0c5239c.png)
Select a pivot table.
In the Pivot Options tab of the Organize
sidebar, do any of the following:
Show or hide Total columns or rows : Click
next to the Column or Row field you want, then select or deselect Show Total Columns or Show Total Rows.
Show or hide Grand Total columns and rows: Click
next to Columns or Rows, then choose Hide Grand Total Column or Hide Grand Total Row.
You can add filtering rules to change what data appears in the pivot table. See Filter data in Numbers on Mac.