Pivot Table Data Crunching for Microsoft® Office Excel® 2007

Chapter 4. Controlling the Way You View Your Pivot Data

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

• Grouping Pivot Fields 83

• Case Study: Creating an Order Lead-Time Report 88

• Case Study: Grouping Text Fields 90

• Looking at the PivotTable Field List 93

• Sorting in a Pivot Table 96

• Filtering the Pivot Table 102

• Case Study: Creating a Top 10 Report 113

• Next Steps 116

</feature>

Microsoft added some excellent new features to Excel 2007’s pivot tables:

• Whenever Mike or Bill entertained an audience with one of his seminars, they could be sure to “wow” the audience with obscure features like the Top 10 AutoShow feature that was buried four menus deep in prior versions of Excel. Microsoft has exposed the AutoSort and AutoShow options so that they are now just ...