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).
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.
The result is shown below.
summary
- Filters are used all the time in Excel data sets and pivots
- Simply uncheck a item in the filter menu
- More than one item can be filtered out