Numbers

Create a pivot table in Numbers on iPad
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.
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.
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.
See alsoIntro to pivot tables in Numbers on iPadAdd and arrange pivot table data in Numbers on iPadChange how pivot table data is sorted, grouped, and more in Numbers on iPadRefresh a pivot table in Numbers on iPadCreate a snapshot of a table in Numbers on iPadFilter data in Numbers on iPadAdd column, bar, line, area, pie, donut, and radar charts in Numbers on iPadSelect cells in a pivot table to create a pivot chart