CHAPTER 6

Modifying a Pivot Table

In this chapter, you'll find solutions for problems you encounter as you make changes to your pivot tables. One of the greatest benefits of using pivot tables is this: after you create a pivot table, you can easily modify it. You can move the fields to a different area of the pivot table, add or remove fields, show or hide items, and make other changes to the layout.

You may encounter problems as you change the layout, with fields that don't behave as expected, or features that are unavailable after you move a field. You may want to alter the labels or values in the pivot table, and have unexpected results when you try to make the changes. Except where noted, the problems in this chapter are based on the Sales_06.xlsx sample workbook.