Ways to Select and Hide Items in PivotTable Fields in Excel 2000 

When a field in a Microsoft Excel 2000 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.