O'Reilly logo

Pivot Table Data Crunching by Michael Alexander, Bill Jelen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required