Chapter 11. Formatting Pivot Tables
In this chapter
Special Considerations When Adding Data Fields to the Value Section 224
As shown in Chapter 10, pivot tables are very fast at creating summary reports from thousands of rows of data. Once you’ve developed the summary information, you might need to spend some time improving the format of the pivot table. Excel 2007 offers some exciting new options in pivot table formatting. Unfortunately, Excel 2007 still offers some annoying problems that have plagued pivot table fans for a decade.
The New Compact View
In the pivot table shown in Figure 11.1, Column A contains three different fields: Region, Product, and Customer. ...
Get Special Edition Using Microsoft® Office Excel® 2007 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.
