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
Hiding Items

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.