Create a pivot table in Numbers for iCloud
You can create a pivot table to organize, group, and summarize data from another table; the data in the other table is your source data. The table containing the source data must contain at least one populated body (nonheader) cell, and can’t contain cells merged across adjacent rows.
Note: If you update the source data, you need to refresh the pivot table to see the changes.
Select (or click a cell in) the table that contains the data you want to analyze.
Click the Pivot Table button
in the toolbar, then choose whether to add the pivot table to the existing sheet or a new sheet.An empty pivot table is added in the chosen location, and the Pivot Options tab opens in the Organize
sidebar on the right.In the Pivot Options tab of the Organize
sidebar, select the fields (columns of data from the source table) that you want to add to your pivot table. For detailed instructions, see Add and arrange pivot table data.
Tip: To quickly go to the source data for a pivot table, select the pivot table, then in the Pivot Options tab in the Organize sidebar, click the source table name (below Source Data).