Page 705 - Excel 2013 All-in-One For Dummies

Modifying the Pivot Table
As the name pivot implies, the fun of pivot tables is being able to rotate the data fields by using the rows and columns of the table, as well as to change what fields are used on the fly. For example, suppose that after making the data list’s Location field the pivot table’s Column Labels Field, and its Dept field the Row Labels Field, you now want to see what the table looks like with the Dept field as the Column Labels Field and the Location field as the Row Labels Field.
No problem: All you have to do is open the PivotTable Fields task pane (Alt+JTL) and then drag Location from the COLUMNS area to the ROWS area and then drag Dept from the ROWS to COLUMNS. Voilà — Excel rearranges the totaled salaries so that the rows of the pivot table show the location grand totals, and the columns now show the departmental grand totals. Figure 2-11 shows this new arrangement for the pivot table.
In fact, when pivoting a pivot table, not only can you rotate existing fields, but you can also add new fields to the pivot table or assign more fields to the table’s COLUMNS and ROWS areas.
Modifying the Pivot Table 687
Figure 2-11:
Pivoting the table so that Dept is now the Column Labels
Field and Location the Row Labels Field.
Book VII Chapter 2
Generating Pivot Tables