Create a pivot table in Numbers on Mac
You can create a pivot table to organise, group and summarise data from another table; the data in the other table is your source data.
Source tables for pivot tables must:
Have at least one cell with data that’s not a header cell.
Not include cells merged across adjacent rows.
If you create a pivot table from a range of cells, you can edit the range later.
If you update the source data in the original table, you need to refresh the pivot table to see the changes.
Create a pivot table
Select a table or range of cells in your spreadsheet.
Tip: To quickly add a pivot table to a new sheet, select a table, then choose Pivot Table
in the toolbar.In the Numbers menu bar at the top of your screen, choose Organise > Create Pivot Table, then choose one of the following:
On New Sheet: Creates a pivot table on a new sheet using the entire table as source data.
On Current Sheet: Creates a pivot table on the current sheet using the entire table as source data.
For Selected Cells on New Sheet: Creates a pivot table on a new sheet using only the selected cells as source data.
For Selected Cells on Current Sheet: Creates a pivot table on the current sheet using only the selected cells as source data.
When you create a pivot table, it is blank until you add fields. See Add and arrange pivot table data in Numbers on Mac.
Change the cell range of your source data
If you create a pivot table from a range of cells, you can edit the range to change the data used in the pivot table.
Select a pivot table, then, in the Pivot Options tab of the Organise
sidebar, click the cell range below Source Data.Edit the range, then choose
.
Delete a pivot table
To delete a pivot table, select it, then press the Delete key.
When you create a pivot table, you can create a chart to display the summary data. See Select cells in a pivot table to create a pivot chart.