To further refine the layout of a PivotTable or PivotChart report , you can display or hide items or levels in a row label or column label.
What do you want to do?
Display or hide items in a PivotTable report
You can hide specific items in a row label or column label to help you eliminate unnecessary information from your PivotTable report. Hiding an item in a row label or column label removes the item from the report, but the item still appears in the drop-down list for the label.
Select one or more of the items that you want to display or hide.
Right-click the selection, point to Filter, and then click Hide Selected Items or Keep Only Selected Items.
If items are hidden and you want to display those items, right-click a related item, point to Filter, and then click Clear Filter.
Display or hide levels in a PivotTable or PivotChart report
You can also hide levels that you don't want to view in your report. For example, you may want to hide a state/province level because the country/region that you are analyzing has no data for states or provinces, and you want to make the report more readable. You can hide levels between the highest and lowest levels of an Online Analytical Processing (OLAP) hierarchy. Any level of a hierarchy can be hidden at any time unless it is the only level available (a one-level hierarchy) or unless it is the only level that isn't hidden.
Note: This procedure applies only to a PivotTable or PivotChart report that is connected to an OLAP data source.
Select a field or data series in a dimension hierarchy in the PivotTable or PivotChart report for which you want to display or hide a level.
Right-click the field or data series , point to Show/Hide Levels, and then click Show All Fields, Hide All Fields, or a specific level in the hierarchy.