Pivot Table Data Crunching: Microsoft

3. Customizing a Pivot Table

In This Chapter

Making Common Cosmetic Changes 46

Making Layout Changes 51

Case Study: Converting a Pivot Table to Values 55

Customizing the Pivot Table Appearance with Styles and Themes 58

Changing Summary Calculations 63

Adding and Removing Subtotals 65

Using Running Total, % of, Rank Options 66

Case Study: Handling Impossible Calculations with GetPivotData 75

Although pivot tables provide an extremely fast way to summarize data, sometimes the pivot table defaults are not exactly what you need. In this case, 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.

In Excel 2010, ...