Hide Pivot Table Detail Without Filtering

Hide Pivot Table Detail Without Filtering

To focus on specific data in a pivot table, you can use report filters or field filters. You can also hide Pivot Table detail without filtering — use the expand and collapse buttons to show or hide details.

Pivot Table Report Filters

This screen shot shows a pivot table with East selected in the Region report filter.

FilterIntro07

However, using those filters affects the pivot table subtotals and grand totals. Only the amounts for the filtered data are included in the results.

FilterIntro01

Collapse or Expand the Fields

Another option for hiding the pivot table details is to collapse one or more of the items, so only its subtotal is showing. In the screenshot below, I’m about to click on the Collapse button for the Bars category in the pivot table.

PivotTableExpand02

The Bars data is still in the pivot table, but only its subtotal is showing, not the City detail rows. The subtotals for East and Bars are not affected.

PivotTableExpand03

Show the Details Again

After you’re finished focusing on the specific data, you can show all the detail rows again.

A quick way to show all the details for a field is to right-click on an item in the field, such as Bars.

Then, in the popup menu, click Expand/Collapse, and click Expand Entire Field.

PivotTableExpand01

Watch the Pivot Table Video

To see the steps for hiding or showing the detail items in a pivot table, watch this short Excel video.

___________

2 thoughts on “Hide Pivot Table Detail Without Filtering”

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.