To focus on specific data in a pivot table, you can use report filters or field filters.

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

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.

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.

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

Continue reading Hide Pivot Table Detail Without Filtering