How to Filter within a Pivot Table

Filtering is commonly used in Pivot Tables to enable the user to add and remove items as needed.

In this case, we have two pivot tables and one pivot table is displaying a grand total row that is not desired (highlighted orange).

Undesired row in a PivotTable.

To filter out any unwanted row labels, simply click on the arrow in the pivot table and remove the undesirable label as seen below and click OK.

The items can also be selected and deselected using arrow keys and the spacebar.

Read more about these hotkeys and other hotkeys here

Filtering to remove a row from a pivot.

The result is shown below.

Filtered PivotTable.

summary