Pivot Table Data Crunching

5. Controlling the Way You View Your Pivot Data

In this Chapter

Showing and Hiding Options 71

Sorting in a Pivot Table 79

Producing Top 10 Reports 88 88

Grouping Pivot Fields 91

Showing and Hiding Options

By their nature, pivot tables will summarize and show the data from all records in your dataset. There may, however, be situations when you want to inhibit certain data items from being included in your pivot table summary. In these situations, you can choose to hide a data item.

The Basics of Hiding an Item

When you hide a data item, you are not only preventing the data item from being shown on the report, you are also preventing it from being factored into the summary calculation.

Figure 5.1 shows a pivot table with Market in the row area. ...