Excel Pivot Table: Filter Values Greater Than a Number

Charts & pivot tables · Updated November 19, 2026

To show PivotTable items whose summarized value exceeds a threshold, open the drop-down for the row or column field, choose Value Filters > Greater Than, select the value field to compare, and enter the threshold. Excel keeps items whose chosen summary is strictly greater than that number; it does not delete or alter the source data.

What a greater-than PivotTable filter does

A PivotTable Value Filter compares a summary for each item in a row or column field. For example, if a PivotTable lists regions in rows and sums sales, filtering the Region field for Sum of Sales greater than 15,000 shows only the regions whose summarized sales exceed 15,000. The comparison is against the PivotTable result for each region, not against every individual sales transaction.

The word greater is literal: a value equal to the threshold does not pass. If a region totals exactly 15,000, it is excluded by Greater Than 15,000. To include it, use Greater Than Or Equal To instead. This distinction matters when a threshold is a target, minimum, or cutoff that should include an exact match.

Value Filters are useful for questions such as which products sold more than a set quantity, which employees handled more than a given number of orders, or which months had revenue above a target. They filter the visible PivotTable categories while leaving the underlying records intact.

How to apply the filter in Excel for Microsoft 365

In Excel for Microsoft 365 on Windows, first make sure the PivotTable includes the category field you want to screen in Rows or Columns and the numeric measure you want to assess in Values. Then use the field’s drop-down in the PivotTable itself:

  1. Click the drop-down arrow beside the row or column field heading, such as Row Labels or Region. If the PivotTable uses separate field headings, use the arrow beside the appropriate field.
  2. Point to Value Filters, then choose Greater Than. The menu is attached to the category field whose items will be kept or hidden.
  3. In the Value Filter dialog, select the measure to test, such as Sum of Sales. Confirm that the comparison is greater than, then enter the cutoff value.
  4. Choose OK. The PivotTable displays only category items meeting the condition.

For instance, if the value field is Sum of Sales and the cutoff is 15000, the condition means Sum of Sales > 15000 for each listed category. Enter a number without currency symbols if Excel expects a numeric value; number formatting controls how results appear, but the underlying comparison uses the value. For currency, 15000 and a displayed $15,000 represent the same numeric threshold.

In the desktop Mac version, the same Value Filters approach is available in PivotTable field drop-downs, though the ribbon and dialog layout can differ slightly from Windows. Excel for the web may present a more compact interface; if the expected command is not visible, open the workbook in the desktop app and apply the filter there.

Choose the right summary field

The field selected in the Value Filter dialog determines what Greater Than means. A PivotTable can summarize the same source column in different ways, so check that the dialog uses the intended calculation.

  • Sum of Sales: keeps categories whose total sales exceed the cutoff.
  • Count of Orders: keeps categories with more than the specified number of records or order entries.
  • Average of Rating: keeps categories whose average rating is above the threshold, not those whose total ratings are above it.
  • Max of Amount: keeps categories when their single largest amount is above the cutoff.

If Excel has summarized a numeric field as Count instead of Sum, the source values may be stored as text, or the selected field may contain nonnumeric entries. Check the Values area and, if needed, change the summary using Value Field Settings. A filter that is technically working on Count can still answer the wrong business question if you expected a total.

With more than one value field, select the specific measure in the dialog. For example, a PivotTable showing both Sum of Sales and Count of Orders needs an explicit choice: sales greater than 15,000 is not the same test as order count greater than 15,000.

Worked example: sales by region

Suppose a source table has one row per sales transaction, with Region and Sales columns. The PivotTable places Region in Rows and Sales in Values, summarized by Sum. Before filtering, it shows these totals:

  • East: 18,400
  • West: 12,750
  • North: 9,300
  • South: 21,100

Applying a Value Filter to Region with Sum of Sales greater than 15,000 leaves East and South. West and North are hidden because their totals fall below the cutoff. If West were exactly 15,000, it would still be hidden under Greater Than; choosing Greater Than Or Equal To would include it.

This example also shows why a Value Filter differs from filtering the source Sales column. A transaction-level filter for sales above 15,000 would look for individual records whose sale amount crosses that threshold. The PivotTable value filter instead adds or summarizes the records for each region first, then tests each regional total.

How the filter interacts with the PivotTable

A Value Filter hides category items from the PivotTable display; it does not remove source rows, change totals in the source table, or rewrite the workbook’s data. Clearing the filter restores the hidden categories. Other report filters, slicers, and field filters can also affect which records contribute to a PivotTable’s displayed summaries, so the totals being compared may reflect those selections.

When a PivotTable has several fields in Rows, apply the filter to the field whose items should be compared. A filter on Product tests product summaries; a filter on Category tests category summaries. The resulting view can also be affected by the hierarchy and any other field selections, so check the field heading and the selected measure if results seem unexpected.

After source data changes, refresh the PivotTable with PivotTable Analyze > Refresh on Windows, or right-click the PivotTable and choose Refresh. The Value Filter condition remains in place, but the items shown can change when refreshed totals move above or below the cutoff. If new records are not part of the PivotTable’s source range, refreshing alone will not include them; update the source range or use an appropriately sized Excel Table as the source.

Sorting and filtering are separate operations. You can sort the remaining items by their values after applying the filter, but sorting alone does not hide categories below a threshold. A Top 10 filter is also different: it selects a ranked number or percentage of items, whereas Greater Than applies a fixed numeric cutoff.

Common problems and fixes

  • Value Filters is missing or unavailable. Confirm that you opened the drop-down for a field in Rows or Columns. The command filters category items; it is not usually found by opening the drop-down for a value cell. Also confirm you are working inside the PivotTable.
  • The result uses the wrong calculation. Reopen the filter and inspect the selected value field. If the field is summarized by Count rather than Sum, correct the summary in Value Field Settings before judging the result.
  • No items remain. Check whether the threshold is too high, whether the selected measure is correct, and whether other report filters or slicers have reduced the data being summarized. Remember that equal values do not pass a strict Greater Than condition.
  • A category expected to pass does not appear. Refresh the PivotTable, confirm the source range includes the relevant records, and check for filters elsewhere in the report. Also verify that the displayed number is not rounded: a value shown as 15,000 may actually be 14,999.6 or 15,000.4.
  • Text or blank entries behave unexpectedly. Value Filters work on summarized values. Clean numeric fields in the source and check how blanks or text are being summarized; they may not contribute to a Sum in the way a numeric amount does.

One common misconception is that applying the filter permanently removes the excluded categories. It does not. The filter controls the current PivotTable view, and clearing it or changing the threshold can show those categories again. For a report intended for other people, label the measure and cutoff clearly so readers understand what has been hidden.

Value Filters compared with other filters

Choose the filter type based on the question being asked. A Value Filter tests an aggregate such as sum, count, or average. A Label Filter tests the category’s text, such as product names beginning with a particular letter. A Report Filter or slicer narrows the records included in the PivotTable by a selected field value, such as showing one year or one department.

For example, to show only products whose total units sold exceed 500, use a Value Filter on the product field and choose the units measure. To show product names containing the word Coffee, use a Label Filter. To limit the whole report to 2025, filter the year field or use a slicer. These operations can be combined, but each answers a different question.

Use Greater Than when the cutoff itself is meaningful and stable. Use Top 10 when the goal is to show the highest-ranked items regardless of their actual values. If the requirement is to filter individual transactions before summarizing, filter the source records or add a suitable field filter instead of using a Value Filter on the aggregated result.

Alternatives when a PivotTable filter is not enough

If you need a reusable report with a threshold that readers can change frequently, a PivotTable Value Filter is usually the simplest option. It is quick to apply and recalculates its displayed membership after refresh. For more elaborate rules, consider a helper column in the source data, a PivotTable calculated field where suitable, or a separate summary built with worksheet formulas. Each choice has trade-offs: source helper columns classify individual rows, while a Value Filter evaluates the PivotTable’s grouped summaries.

For a one-time look at records above a cutoff, use a filter on the source table’s numeric column rather than building a PivotTable. For an auditable reporting process, document the selected value field, aggregation method, threshold, and any slicer selections. That makes it easier for someone else to reproduce the output and distinguish a group total from a transaction-level test.

Frequently Asked Questions

How do I filter a PivotTable for values greater than a number?
Open the drop-down for the row or column category field, choose Value Filters > Greater Than, select the summary field, enter the cutoff, and select OK.

Does Greater Than include a value equal to the cutoff?
No. It is a strict comparison. Choose Greater Than Or Equal To if items exactly at the cutoff should remain visible.

Does the filter compare each source row or the PivotTable total?
It compares the selected summarized value for each item in the field being filtered. To test individual source records, filter the source data instead.

Can I filter by Sum of Sales when the PivotTable also shows order counts?
Yes. In the Value Filter dialog, choose Sum of Sales as the measure. Check the selected field carefully so the condition is not applied to Count of Orders by mistake.

Why did my PivotTable results change after refresh?
A refresh updates summaries from the source data. Categories can then cross the cutoff in either direction. Confirm that the source range includes the latest records and that no other filters are changing the data included in the totals.

Related

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.