When a field in a PivotTable® report that's based on source data from an OLAP database has hundreds of items, you need a quick way to select and hide the ones you want. In the drop-down list for a row or column field, you can use the check box for a higher-level item to control the items displayed for the next level down.

• Initially, a top-level item has a single check, indicating that the item is selected for display, but none of its next-level items are selected:

  

  
  

• Click the check box for USA once to double-check it and display all of the items for the states:

  

  
  

• Click the USA check box a second time to hide all of the state items:

  

  
  

• Now you can click only the states you want to display:

  

  
  

Items that are single-checked or double-checked are displayed in the PivotTable report. USA is double-checked whenever any or all of the states are selected for display. The report will now display items USA, OR, and any other states you select.

For more information about displaying and hiding items in PivotTable fields, type hide PivotTable items in the Office Assistant or on the Answer Wizard tab in the Excel Help window, and then click Search.