To change a pivot select the pivot to modify in the Pivot Options window and click the Edit Pivot button


This will bring up the Pivot Designer.

Checking The fields in the list will make them available in the pivot grid.  The fields in the Filter Area, Row Area, Column Area and Data Area boxes can be dragged between the boxes to change what areas the field will show up in.

See also