Pivot Table Value Filter Not Working? Fix It in Excel

If a PivotTable value filter is not working, first confirm that you applied it to a field in the Rows or Columns area and selected the correct value field to test. Then refresh the PivotTable and check the source data and other active filters; a value filter evaluates summarized PivotTable results, not individual source rows.

How PivotTable value filters work

A value filter keeps or hides items in a PivotTable field according to an aggregate such as Sum of Sales, Count of Orders, or Average of Units. For example, a filter on the Region field can show only regions whose Sum of Sales is greater than $50,000. It does not delete records from the source table, and it does not automatically mean that each transaction in a displayed region is above that threshold.

This distinction matters because the PivotTable may contain several row and column fields, and the same field can be summarized in more than one way. A product might have a Sum of Sales of $12,000 but an Average of Sales of $40. The value filter must use the measure that matches the question you are asking.

In Excel for Microsoft 365 on Windows, value filters are accessed from a row or column field’s dropdown. They are different from:

Label Filters, which test item names, such as product names beginning with a letter.
Report filters, which select a category for the whole PivotTable.
Source-data filters, which hide or remove records before or while the PivotTable is built.

A PivotTable’s grand total is not an item in the field being filtered. A value filter on Region, for instance, filters the region items; it is not a command to hide the grand total whenever that total fails the chosen condition.

Apply the filter to the right field

Start with the field whose items you want to keep or hide. That field must be in the Rows or Columns area. A value filter is not applied by opening a dropdown for a field in the Filters area or by filtering the Sum of Sales cell itself.

Click the dropdown beside the row or column field whose items should be filtered. In a compact layout, this may be the Row Labels or Column Labels dropdown.
Choose Value Filters, then choose the condition, such as Greater Than, Between, or Top 10.
In the dialog, select the value field to evaluate, such as Sum of Sales, and enter the threshold or ranking settings.
Choose OK, then inspect the field dropdown to confirm that a filter is active.

For instance, to show products with sales above $10,000, open the Product field dropdown, choose Value Filters > Greater Than, select Sum of Sales, enter 10000, and confirm. Choosing the Region dropdown instead would filter regions, not products. Choosing Count of Sales instead of Sum of Sales would test a different measure.

On Excel for Mac, the same general field-dropdown and Value Filters approach applies, though ribbon and menu placement can vary by release. If the command is not visible, check that the selected field is in Rows or Columns and use the field’s own dropdown rather than a value cell.

Check the value field and calculation

A common reason for surprising results is that the filter is evaluating the wrong calculation. In the filter dialog, check the value-field name carefully. If the PivotTable has several measures, Excel may offer Sum of Revenue, Count of Revenue, and Average of Revenue as separate choices. A filter set to Count can keep items with many records even when their total revenue is low.

Also inspect how Excel summarizes the field. Right-click a value in that field and choose Summarize Values By to see the available calculation and the current selection. If a column expected to contain numbers includes text or blanks, Excel may summarize it differently than expected, or the source may contain values that do not behave like numbers. Check several original records and confirm that the value field is numeric and consistently populated.

Formatting can add to the confusion. A value displayed as currency may be rounded to whole dollars even though the underlying amount includes cents. A filter threshold operates on the underlying values, not merely the rounded appearance. If a displayed value looks equal to a threshold, inspect its source value or temporarily increase the displayed decimal places before deciding the filter has failed.

Refresh the PivotTable and verify its source

A PivotTable can show old results when its source data has changed but the PivotTable has not been refreshed. Click inside the PivotTable and choose PivotTable Analyze > Refresh. To update all PivotTables and connections in the workbook, use Data > Refresh All. Refreshing updates the PivotTable from its current source; it does not necessarily expand a fixed source range to include new rows.

If recently added records are missing, click inside the PivotTable and check PivotTable Analyze > Change Data Source. Confirm that the source range includes the new rows. Converting a growing source range into an Excel table with Insert > Table can make later additions easier to include: when the PivotTable uses that table as its source, refresh it after adding records.

Check for less obvious source issues too. A new row may sit outside the range, a value may have been pasted into the wrong column, or a date or number may be stored as text. If the PivotTable is built from the Data Model or an external connection, refresh status and connection settings can also affect which records are available.

Look for other filters and field interactions

Value filters can operate alongside label filters, report filters, slicers, timelines, and filters on other row or column fields. The visible result reflects the active combination. For example, a Region report filter may limit the PivotTable to one region before you evaluate products by sales. A slicer selection can also make a product appear to fall below a threshold because fewer records are currently included.

Open the relevant field dropdown and look for the funnel icon or filter indicators. Check slicers and timelines, and review report filters above the PivotTable. To isolate the cause, clear one filter at a time and see whether the expected item returns. Use the field dropdown’s clear-filter command only when you intend to remove that field’s filter; clearing one field does not necessarily clear slicer selections or filters elsewhere.

With multiple fields nested in Rows, pay attention to which level’s dropdown you use. Filtering a parent field such as Region is not the same as filtering a child field such as Product. Expand the relevant levels and verify the items under the field you filtered. The PivotTable layout and other filters determine the context of the summarized values, so compare like with like when checking results.

Distinguish hidden items from zero or blank values

An item that appears to survive a value filter may actually have a blank or zero result, or may be displayed because of the field’s layout settings. Check whether the value cell is truly blank, contains zero, or displays a dash because of number formatting. These are different states, and a measure or calculation may return a blank even when the source contains records.

Also check whether the field is set to show items with no data. That setting can make categories visible even when they have no matching values in the current view, which can look like a filter has left an item behind. Turn the setting off temporarily if appropriate and compare the displayed items. Do not assume that every visible category represents a positive sum or a matching source record.

Grand totals and subtotals are summaries of the PivotTable’s displayed structure, not additional field items to which the same item filter applies. If a subtotal seems inconsistent, expand the group and compare the individual items and the selected aggregation. Formatting, hidden rows, and collapsed groups can also make it difficult to tell which items remain in the filtered result.

A quick troubleshooting sequence

When the filter appears to do nothing, use this sequence to narrow down the cause rather than rebuilding the PivotTable immediately:

Open the dropdown for the exact row or column field whose items should change.
Confirm that you chose Value Filters, not Label Filters, and selected the intended calculation, such as Sum of Sales.
Temporarily use an obvious condition, such as Greater Than 0, to check whether the item list changes.
Review all report filters, slicers, timelines, and other field filters that restrict the data.
Refresh the PivotTable and confirm that the source range or connection includes the records you expect.
Check the source values for text numbers, blanks, duplicates, or values in the wrong column.
Clear the test condition and reapply the intended threshold once the field and data are verified.

If an obvious test condition changes the list but your intended threshold does not, the filter is functioning; the selected measure, threshold, or aggregation is probably not what you meant. If even the test condition has no visible effect, check the field placement and whether the item list is being affected by another filter or display setting.

When a value filter is not the right tool

A value filter is useful when the question is about grouped results, such as which customers have total purchases above a threshold. It is not the right tool when you need to remove individual source records that fail a condition, such as transactions below $100. For that, filter the source table, or add a suitable helper column and use it as a PivotTable field. Be clear about whether you need to exclude records before aggregation or exclude groups after aggregation; those operations answer different questions.

Another alternative is to use a worksheet formula or a regular Excel table filter when you need to inspect individual records directly. Keep the PivotTable when you need summaries by category, and use its value filter to hide categories based on those summaries. If the business rule is more complicated than a standard comparison or Top 10 condition, a helper field or a separate summary calculation may be easier to audit than stacking several PivotTable filters.

Frequently Asked Questions

Why is Value Filters greyed out in my PivotTable?
Check that you opened the dropdown for a field in the Rows or Columns area. The command may not be available from a value cell or a field in the Filters area. Also confirm that the PivotTable has a value field to evaluate.

Why does my value filter show the wrong products?
Open the filter dialog and verify both the filtered field and the measure being tested. A Product filter using Count of Sales can return a different list from one using Sum of Sales. Review other active filters as well.

Does a value filter remove rows from the source data?
No. It hides PivotTable items based on summarized values; the underlying records remain in the source. Use a source-table filter or another record-level method if individual records need to be excluded.

Why are new records missing from the filtered PivotTable?
Refresh the PivotTable and check its data source. If the source is a fixed range, it may not include newly added rows. Update the source range or use an Excel table as the source, then refresh.

Can I filter by average instead of sum?
Yes, if the value field offers that summary. Choose the relevant field and Average in the value-filter dialog. Make sure the average is the measure your question requires, since it can produce a different result from a total.

Why does an item with no sales still appear?
It may have a zero or blank result, be included by another setting such as Show items with no data, or be affected by the PivotTable layout. Check the underlying values, field settings, and active filters before treating it as a failed value filter.

Bottom line

Most apparent PivotTable value-filter failures come down to filtering the wrong field, testing the wrong aggregation, using stale source data, or overlooking another active filter. Verify the field dropdown, value calculation, source range, and filter context in that order. Once those match your goal, the value filter should produce a list that is easier to explain and trust.

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.