Excel Pivot Table Value Filter Not Working? Fixes

If an Excel PivotTable value filter is not working, first confirm you applied it to a row or column field and selected the correct value field in the filter dialog. Then refresh the PivotTable and check whether other filters, the value calculation, or the filter condition explains the result; value filters remove PivotTable items based on their summarized values, not individual source rows.

How a PivotTable value filter works

A value filter keeps or hides items in a PivotTable field according to a calculation in the Values area. For example, you can show only sales regions whose total sales exceed $10,000, or products that rank in the top 10 by units sold. The filter is applied to the items in a row or column field, such as Region or Product, using a selected measure such as Sum of Sales.

That distinction matters: a value filter is not the same as a label filter. A label filter checks the item name—for example, whether a product name begins with a particular letter. A value filter checks the result calculated for that item. It also does not delete source records or directly filter individual transactions. It hides categories in the PivotTable whose summarized results do not meet the condition.

The measure is calculated in the context of the current PivotTable. Other report filters, slicers, and field selections can change the totals used to decide which items pass. A region that passes a sales threshold when all years are selected might fail after a slicer limits the report to one quarter.

Apply the filter to the right field

In Excel for Microsoft 365 on Windows, open the drop-down beside a row or column field, choose Value Filters, and select a condition such as Greater Than, Top 10, or Between. Complete the dialog and choose the value field that should determine which items remain. The field you open is the field whose items will be filtered; the value field is the measure used to test them.

Click a cell in the PivotTable and locate the field whose items you want to include or exclude, such as Region.
Open that field’s drop-down arrow. If the arrows are hidden, select the PivotTable, then use PivotTable Analyze > Show > Field Headers to display them.
Choose Value Filters and the condition you need. For a threshold, choose Greater Than or Between; for a ranking, choose Top 10.
In the dialog, check the value field shown in the condition, such as Sum of Sales, and enter the threshold or ranking settings.
Select OK, then inspect the field’s filter icon to confirm a filter is active.

If the PivotTable contains more than one measure—for example, Sum of Sales and Count of Orders—the dialog may be using a different measure than you expect. Select the intended one explicitly. On Mac, the same general operation is available from the PivotTable field drop-down, although ribbon placement and dialog appearance can vary by Excel version. Excel for the web may expose fewer PivotTable controls than desktop Excel; if a setting is unavailable, open the workbook in the desktop app.

Check the condition and the value calculation

A filter can be active and still appear ineffective when its condition does not mean what you intended. Greater Than 10,000 excludes items equal to 10,000; Greater Than Or Equal To includes them. Top 10 usually means the top ten items, not items whose values exceed ten. In the Top 10 dialog, check whether the unit is Items, Percent, or Sum, and whether the ranking is based on the correct measure.

Also verify how the value field is summarized. Click a value in the relevant column, right-click, and choose Summarize Values By to inspect choices such as Sum, Count, and Average. Sales stored as numbers are commonly summarized by Sum, but a field containing text or blanks may be counted instead. If the displayed calculation is Count of Sales, a threshold intended for currency will not behave as expected.

For a different calculation, use Value Field Settings. Right-click a value in the field and choose Value Field Settings, then review Summarize Values By and, if relevant, Show Values As. Options such as % of Grand Total, Running Total In, or Difference From change the displayed result. A value filter is evaluated against the measure and calculation represented in the PivotTable, so confirm the calculation before troubleshooting the condition itself.

Refresh the PivotTable and verify its source data

PivotTables can retain a cached view of source data. If records were added, edited, or removed after the PivotTable was created, its values may be out of date. Select a PivotTable cell and choose PivotTable Analyze > Refresh. To refresh all connections and PivotTables in the workbook, choose Data > Refresh All. On Mac, refresh commands are also available from the PivotTable or Data ribbon, though exact placement can differ.

Refreshing will not fix a source range that excludes newly added rows. Select the PivotTable, choose PivotTable Analyze > Change Data Source, and inspect the range or table name. A source Excel table is often easier to maintain because adding records to the table can extend the PivotTable’s source automatically; refresh the PivotTable afterward to load the additions.

Check the source values behind a category that seems wrong. Numbers stored as text, blank cells, inconsistent category spellings, or unexpected spaces can affect grouping and summaries. For example, East and East followed by a space may appear as separate items, each with a smaller total. Correct the source data, refresh the PivotTable, and then reapply or review the value filter.

Account for other filters, groups, and layout

Value filters operate alongside other PivotTable filters. A report filter, slicer, timeline, or another row or column filter can change the population being summarized. To isolate the cause, temporarily clear other filters, refresh, and apply the value filter again. If the result changes, restore the other filters one at a time to identify which selection changes the totals.

Grouped dates and manually grouped items can also make results less obvious. A date value filter may be testing months or quarters rather than individual transaction dates if the date field has been grouped. Similarly, a grouped set of products may be evaluated as a group rather than as the original individual labels. Expand the group or review the field structure if the visible items do not match the level you meant to filter.

In Compact Form, several row fields share a single label column, which can make it unclear which field’s drop-down you opened. Use the field name in the drop-down or change the report layout from PivotTable Design > Report Layout to a clearer form, such as Show in Tabular Form. The layout changes presentation, not the underlying source data, but it can make filter ownership easier to see.

Common symptoms and practical fixes

The Value Filters menu is missing: Open the drop-down for a row or column field, not a cell in the Values area or a report-filter field. Confirm a cell inside the PivotTable is selected.
The filter dialog shows the wrong measure: Choose the intended field, such as Sum of Sales rather than Count of Sales, in the dialog’s value-field selector.
Items that should fail remain visible: Check whether another field is being filtered, whether the condition includes equality, and whether the summarized value is a sum, count, average, or displayed percentage.
Expected items are absent: Clear other filters and slicers, inspect the source range, and refresh. The category may have no records in the current filter context.
The filter seems to undo itself: Reopen the field menu and review the active condition. Editing the PivotTable layout, changing the measure, or applying another filter can alter the result; setting the condition again after those changes can clarify what is active.
Values look right but the threshold is not: Check number formats and underlying values. A cell formatted as currency may display rounded amounts, while the filter evaluates the actual stored numbers.

A reliable troubleshooting sequence

Use this sequence to find the cause without changing the source data unnecessarily:

Click inside the PivotTable and identify the exact row or column field whose items should be filtered.
Check the value field’s summary—for example, Sum of Revenue—and make sure it is not Count or an unintended Show Values As calculation.
Clear other filters or slicers temporarily, then apply a simple condition with an unmistakable threshold.
Refresh the PivotTable and confirm its source includes the records you expect.
Inspect source categories, blanks, and number types if totals or labels appear inconsistent.
Reapply the intended condition, restore other filters one at a time, and confirm the outcome after each change.

For a quick check, compare a few visible item totals against the underlying records using the same filters. If a region has sales of 9,800 and the condition is Greater Than 10,000, it should disappear; if it remains, check whether the filter is based on a different measure or a different field. If the region total is actually 10,200 after accounting for the current slicer selections, its presence is expected.

When a label filter or source-data filter is a better choice

Choose the filter type based on the question. Use a label filter when the decision depends on text, such as keeping product codes that begin with A. Use a value filter when the decision depends on a PivotTable summary, such as showing departments with an average score above 80. Use a report filter, slicer, or source-data filter when you need to limit the records being analyzed, rather than merely hide categories that fail a summarized-value test.

A common misconception is that hiding a PivotTable item with a value filter removes its underlying records from the workbook. It does not. The filter changes which items are displayed in that PivotTable; the source table remains intact, and another PivotTable based on the same data can show different items or totals.

Frequently Asked Questions

Why is Value Filters greyed out in Excel?
Usually, the selected drop-down belongs to the wrong area. Open the menu for a row or column field and make sure the active cell is inside the PivotTable. If the control is still unavailable, try the desktop version rather than Excel for the web.

Does a PivotTable value filter use the grand total?
It normally tests the summarized value for each item in the selected field, using the chosen value field and the current report context. It does not simply compare every item with the grand total. Other filters and slicers can change those item-level results.

Why does my Top 10 filter show fewer than ten items?
The current report context may leave fewer than ten eligible items, or ties and other filters may affect what is displayed. Check the Top 10 dialog’s Items, Percent, or Sum setting and clear other filters briefly to compare.

Will refreshing remove my value filter?
A refresh updates the PivotTable from its source and commonly retains its field filters, but the visible result can change because the underlying values or available items changed. Review the filter after refreshing, especially if the source range or PivotTable layout was also edited.

How do I remove a value filter?
Open the filtered field’s drop-down and choose Clear Filter From followed by the field name. You can also select the PivotTable and use PivotTable Analyze > Clear > Clear Filters to clear filters from the PivotTable.

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.