Create a pivot table in Numbers on Mac
A pivot table can be created from a table or range of cells in a spreadsheet; the data used in those cells is your source data. The source data must contain at least one populated, non-header cell and can’t contain cells merged across adjacent rows. If you create a pivot table from a range of cells, you can edit the range later.
Create a pivot table
Select a table or select a 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.