Table of Contents
To filter a pivot table in Google Sheets using “greater than” criteria, you can follow these steps: first, select the pivot table and click on the filter icon. Then, choose the column you want to apply the criteria to from the drop-down menu. Next, select “greater than” from the filter options and enter the value you want to use as the criteria. This will filter the pivot table to only show data that is greater than the specified value in the chosen column.
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