Filtering PivotTable data in Google Sheets - Step-by-Step Guide

Introduction

Filtering PivotTable data helps you focus on specific parts of your summary. It lets you hide data you don't need, so you can see only what matters for your analysis.

When you want to see sales data for just one region in your PivotTable.

When you need to analyze only a few product categories from a large list.

When you want to exclude certain dates or months from your summary.

When you want to compare data for specific customers without distraction.

When you want to quickly find trends by focusing on a subset of your data.

Steps

Step 1: Click

- any cell inside the PivotTable

The PivotTable editor panel appears on the right side of the screen

Step 2: In the PivotTable editor, locate the 'Filters' section

- PivotTable editor panel

You see the list of fields currently used as filters or an option to add one

Step 3: Click 'Add' next to Filters

- PivotTable editor panel under Filters

A list of available fields from your data appears for selection

Step 4: Select the field you want to filter by (for example, 'Region')

- Filter field list in PivotTable editor

The filter for that field is added and filter options appear below it

Step 5: Click the dropdown under the filter field to choose filter values

- PivotTable editor under the filter field

A list of all unique values in that field appears with checkboxes

Step 6: Check or uncheck the values you want to include or exclude

- Filter dropdown list

The PivotTable updates to show only data matching the selected filter values

Step 7: Close the filter dropdown by clicking outside it

- Anywhere outside the dropdown

The filter dropdown closes and the PivotTable shows filtered data

Before vs After

Before

PivotTable shows sales data for all regions: North, South, East, West

After

PivotTable shows sales data only for the East region after filtering

Settings Reference

Filters

📍 PivotTable editor panel on the right

To choose which data to show or hide in the PivotTable

Default: No filters applied

Filter values

📍 Dropdown under each filter field in PivotTable editor

To pick specific items to include or exclude from the PivotTable

Default: All values selected

Common Mistakes

Not clicking inside the PivotTable before trying to filter

The PivotTable editor panel does not appear, so you cannot add filters

Click any cell inside the PivotTable first to open the editor panel

Trying to filter by a field not added to the Filters section

Only fields in Filters can be used to filter data in the PivotTable

Add the desired field to Filters before selecting filter values

Unchecking all values in a filter

This results in an empty PivotTable with no data shown

Always keep at least one value selected to see data

Summary

Filtering PivotTable data lets you focus on specific parts of your summary.

You add filters in the PivotTable editor panel by selecting fields and values.

Remember to click inside the PivotTable first and keep at least one filter value selected.