CHAPTER 6Modifying 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 ...
Get Excel 2007 PivotTables Recipes: A Problem-Solution Approach now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
