» Hiding Items
To hide items in a PivotTable report:
In Excel 97, double-click the name of the leftmost Row field, and in Hide Items, select the item to hide, and then click OK.
In all other Excel versions, open the dropdown list of any field and cancel the selection of the items you wish to hide. To open the dropdown list using a keyboard shortcut, press Alt+Down Arrow (or Up Arrow).
You must be very careful when reporting totals after hiding items in a PivotTable report. There is no indication in any field, page, row or column that one or more items are hidden (as opposed to other areas in Excel, for example, when using Automatic Filter in the Filter technique, the color of the dropdown list's arrow changes to blue). It is therefore highly recommended to insert a Comment in a cell to remind you of any hidden items.
|Screenshot // Hiding Items|