Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 3. Customizing a Pivot Table

<feature><title>In This Chapter</title>

• Making Common Cosmetic Changes 46

• Making Layout Changes 52

• Case Study: Converting a Pivot Table to Values 56

• Customizing the Pivot Table Appearance with Styles and Themes 61

• Changing Summary Calculations 65

• Adding and Removing Subtotals 68

• Using Running Total Options 70

• Case Study: Producing Revenue by Line of Business Report 77

• Next Steps 81

</feature>

Although pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults aren’t exactly what you need. You can use many powerful settings to tweak the information in your pivot table. These tweaks range from making cosmetic changes to changing the underlying calculation used in the pivot table. ...