Excel Pivot Tables Recipe Book: A Problem-Solution Approach

CHAPTER 6Modifying a Pivot Table

After you create a pivot table, you can modify it. You can move the fields to a different part of the pivot table, add or remove fields, show or hide items, and make other changes. For some of these tasks, you can use the PivotTable toolbar, which you can also modify, to make your work easier.

6.1. Using Page Fields: Shifting Up When Adding Page Fields

Problem

In the rows above your pivot table, you've entered some worksheet heading text. You dragged another field to the page area, below the existing page field (see Figure 6-1). When you release the mouse button, you get a warning: "Do you want to replace the contents of the destination cells in PivotSheet?" If you click OK, the page fields move up and remove ...