• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 30. Analyzing Data with PivotTab... > Hiding and Showing Inner Field Items

Hiding and Showing Inner Field Items

In the PivotTable shown in Figure 30-2, CatalogNo and Year are outer fields, and Channel and Quarter are inner fields. The PivotTable repeats the items of the inner field for each item in the outer field. You can suppress a set of inner field items by double-clicking the associated outer field item.

For example, to hide the quarterly detail for 2001 in Figure 30-2, you can double-click the 2001 heading. Figure 30-18 shows the result. To redisplay the inner field detail, double-click the outer field heading a second time. Alternatively, you can hide detail by selecting an outer field heading and clicking the Hide Detail tool on the PivotTable toolbar. To redisplay the detail, select the same heading and click the Show Detail tool.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint