December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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. ...