Add and arrange pivot table data in Numbers for iCloud
You choose the data that you want to show in a pivot table by adding fields (columns of data from the source table) to the Columns, Rows, and Values sections in the Pivot Options tab of the Organize 
sidebar, shown below. By default, numeric fields are added to Values, and other nonnumeric fields are added to Columns or Rows. You can also move fields within a section or between sections to change the way data is organized in the pivot table.
Add fields to a pivot table
Click anywhere in the pivot table.
In the Pivot Options tab of the Organize
sidebar, do any of the following:Automatically add fields to Rows, Columns, or Values: Select the checkbox next to the field you want to add.
The field appears in either the Columns, Rows, or Values section, based on the type of data in that field.
Manually add fields to Rows, Columns, or Values: Drag a field from the list to one of the sections (below the Fields list).
After you add the source data you want to analyze, you can reorder and move the fields to change how data is grouped, as described in the next task.
Reorder and move fields
To change how data is grouped in a pivot table, you can reorder fields within a section in the Pivot Options tab, and move fields to other sections. When you reorder and move fields, the pivot table updates automatically to show the new organization.
Click anywhere in the pivot table.
In the Pivot Options tab of the Organize
sidebar, drag a field within a section to change the order of the fields, or drag the field to another section.To quickly swap Column and Row fields, click the More button
next to Columns or Rows, then click Swap Column and Row Fields.
Remove fields
You can remove information from a pivot table by deleting individual fields from a section (in the Pivot Options tab), or deleting all fields in a section. Removing fields does not affect the source data.
Click anywhere in the pivot table.
In the Pivot Options tab of the Organize
sidebar, do any of the following:Remove individual fields: Click the Info button
next to the field you want to remove, then click the Delete button 
in the top-right corner.Remove all fields from a section: Click the More button
next to Columns, Rows, or Values (depending on the section you want to clear), then choose Clear Column Fields, Clear Row Fields, or Clear Value Fields.Tip: You can also remove a field by dragging it out of the section, or by selecting it and pressing the Delete key on your keyboard.
After you add and order the fields how you like, you can change how pivot table data is sorted, grouped, and more.