2007 Microsoft® Office System Inside Out

Rearranging PivotTable Fields

To pivot, or rearrange, a PivotTable, drag one or more field headings from one part of the PivotTable Field List window to another. For example, by using the mouse to change this configuration of the PivotTable Field List window:

to this one:

we can change the table from the form shown in Figure 15-3 to this:

Note

If you don’t see the PivotTable Field List window, select a cell in the PivotTable (it disappears when your selection ...