Google Sheets: Filter Pivot Table Using “Greater Than”


Often you may want to filter values in a pivot table in Google Sheets using a “Greater Than” filter.

Fortunately this is easy to do using the Filter by condition option within a pivot table.

The following example shows exactly how to do so.

Example: Filter Data in Pivot Table Using “Greater Than”

Suppose we have the following dataset in Google Sheets that shows the number of sales of four different products:

Now suppose we create the following pivot table to summarize the total sales for each product:

Now suppose we would like to filter the pivot table to only show rows where the SUM of Sales is greater than 10.

To do so, right click on any cell in the pivot table and then click Create a filter:

Then click the filter icon next to SUM of Sales, then click Filter by condition from the dropdown menu, then choose Greater than, then type in 10:

Once you click OK, the pivot table will automatically be filtered to only show rows where the SUM of Sales is greater than 10:

To remove the filter, simply right click on any cell in the pivot table and then click Remove filter.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: Create Pivot Table with Unique Counts
Google Sheets: Create Pivot Table with Count of Occurrences
Google Sheets: How to Create Pivot Table from Multiple Sheets

Leave a Reply

Your email address will not be published. Required fields are marked *