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

Chapter 5. Controlling the Way You View ... > Showing and Hiding Options

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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