Excel Pivot Table: Add a Field to Filters and Rows

To add a PivotTable field to both a filter and a row, open the PivotTable Fields pane and drag the field from the field list into the Filters area, then drag it from the field list again into Rows. Excel can use the same field in both areas; the report filter controls which items the PivotTable includes, while the row placement displays those items as labels.

What Filters and Rows Mean in a PivotTable

A PivotTable summarizes records from a source range or Excel table. Its field areas determine how that summary is arranged. The Rows area creates labels down the side of the PivotTable, often grouping records by a category such as region, salesperson, or product. The Filters area adds a report filter above the PivotTable so you can include or exclude categories across the entire summary.

These placements answer different questions. If Region is in Rows, you can compare sales by region. If Region is in Filters, you can choose a region and see the rest of the PivotTable for that selection. Putting Region in both areas gives you a report-filter dropdown and row labels for the same field. That can be useful in a specific layout, but it may also be redundant: choosing one region in the report filter usually leaves only that region in the row labels.

Do not confuse a report filter with the dropdown on a row label. The row-label dropdown filters the displayed row items and is attached to that field’s labels. A report filter appears in its own area above the PivotTable and filters the report using a field you place in Filters.

Steps to Add the Same Field to Both Areas

These directions are for Excel for Microsoft 365 on Windows. Start with an existing PivotTable and use the field list to place the field in both areas:

Click any cell inside the PivotTable. Excel displays the contextual PivotTable tabs on the ribbon.
If the field list is not visible, select PivotTable Analyze > Field List.
In the PivotTable Fields pane, find the field you want to use. For example, choose Region.
Drag Region from the field list into the Filters box in the lower part of the pane.
Drag Region from the field list again, this time into the Rows box. Do not drag the existing Region entry out of Filters; use the field name in the list to add another instance.
Check the PivotTable. A Region filter should appear above it, and Region labels should appear down its rows.

If you prefer, use the field’s checkbox to add it to the PivotTable, then move or add fields using the layout boxes. Check the layout after each change: a checked field is not necessarily in the area you want. You can also drag an existing field between areas, but doing so moves that instance rather than creating a second one. If the field disappears from its original area, drag its name from the list into the other area again.

For a more typical arrangement, put one field in Filters and a different field in Rows. For example, put Region in Filters and Product in Rows. The report filter then lets you view products for a selected region, while the row labels continue to show the product breakdown.

What Happens When You Filter the PivotTable

Once the field is in Filters, use the dropdown displayed above the PivotTable to choose an item. Selecting West, for example, limits the report to source records classified as West. The values and row groupings in the PivotTable recalculate to reflect the filtered records. Selecting (All) removes that field’s report-filter restriction and includes all its available items again.

If you want to include more than one item, open the report-filter dropdown and select Select multiple items, then mark the items to include. The precise wording or appearance can vary slightly between Excel builds. When multiple selections are active, the filter control may show an indicator rather than the name of a single selected item, so reopen it to inspect the choices.

When the same field is in Filters and Rows, the report filter constrains the row field. If the filter is set to West, the row labels generally show West rather than a list of every region. That is why users who want a full regional comparison usually leave Region in Rows and put a different field, such as Year, in Filters.

A Concrete Example: Sales by Product and Region

Imagine a source table with columns named Date, Region, Product, and Sales. You want to compare products while letting a manager choose the region. Put Product in Rows, Sales in Values, and Region in Filters. The report filter can then be set to East, West, or another available region, and the PivotTable shows the product sales for that selection. The field placement keeps the choice control separate from the breakdown being compared.

Now suppose you also put Region in Rows. With the filter set to All, the row labels can list the regions, and the manager can select one or more regions at the top. But selecting only West in the report filter leaves a West row in the filtered report. If the goal is to show a single chosen region’s product totals without a redundant Region row, remove Region from Rows and keep Product there.

There is no single correct layout: choose based on what the reader needs to see. Use the same field in both areas when its row label is useful in the report or when matching a required layout. Use separate fields when the filter should control one dimension and the rows should compare another.

Choosing Between a Report Filter and Other Controls

A report filter is straightforward when a reader needs to select a value for the whole PivotTable. It takes little space and works well for a small number of categories. However, a dropdown can be less obvious when a report has many filters or when readers need to compare several selections quickly.

Use Rows when you want a visible breakdown or comparison by category.
Use Filters when a selection should limit the entire PivotTable without becoming its main row or column breakdown.
Use a slicer when you want visible buttons that make filtering easier to understand. Select the PivotTable, then use PivotTable Analyze > Insert Slicer and choose a field.
Use the row-label dropdown when you want to hide particular row items rather than add a separate report-filter control.

A slicer is a separate visual control, not another placement in the Filters box. It can be especially useful for presentations or dashboards because the available choices remain visible. A slicer can also filter a PivotTable built from the same data source when connected appropriately, but do not assume that one slicer automatically controls every PivotTable in a workbook.

Common Problems and How to Fix Them

The field list is missing. Click inside the PivotTable and select PivotTable Analyze > Field List. If the contextual tab is not showing, Excel may not recognize the selected cell as part of the PivotTable.

The field moves instead of appearing twice. Dragging an existing field entry from one layout box to another moves it. Drag the field name from the upper field list into the second area instead. Then check that the field appears in both Filters and Rows.

The filter has no effect or an expected item is absent. Check the source records and the field’s actual values. PivotTables can also retain items that were present in older source data. To review retained items, right-click the PivotTable, choose PivotTable Options, open the Data tab, and check the setting for retaining items deleted from the data source. The available setting can depend on the PivotTable’s source and Excel version.

New records do not appear. Refresh the PivotTable using PivotTable Analyze > Refresh. If the source range does not include the new records, change the source through PivotTable Analyze > Change Data Source, or use an Excel table as the source so added rows are easier to include on refresh.

The report filter shows one item when you expected several. Open its dropdown and enable Select multiple items, then choose the desired values. Also check whether a row-label filter or another report filter is restricting the same data.

Excel for Mac and Excel for the Web

The basic approach is the same in Excel for Mac: select the PivotTable, show its field list or field pane, and place the field in the Filters and Rows areas. Ribbon labels and pane layout can vary by Mac release, so look for the contextual PivotTable tab and the field-list control if the Windows path is not displayed exactly. The field-placement idea does not depend on a Windows-only feature.

Excel for the web also supports working with PivotTables, though available commands and the field-pane layout can differ from the desktop application and may change over time. If a particular option is not visible in the browser, open the workbook in the desktop app and use the PivotTable Analyze controls there. In either version, verify that the field appears in both areas and that the filter behaves as intended.

Frequently Asked Questions

Can the same field be in Filters and Rows in an Excel PivotTable?
Yes. Add it to one area, then drag the field name from the field list into the other area. Avoid dragging the existing layout entry if you want to keep the first placement, because that action moves it.

Why does my row field show only one item after I use the report filter?
The report filter applies to the whole PivotTable. If it filters the same field that is in Rows to one item, the row labels are limited to that item. Use a different field in Filters if you want to keep a full row comparison.

How do I add a filter without changing the row labels?
Place a different field in Filters. For example, leave Product in Rows and put Region in Filters. Selecting a region will filter the report while Product remains the category shown down the rows.

How do I remove a field from the Filters area?
Click inside the PivotTable to show the field list, then drag the field out of the Filters box or clear its checkbox if the pane’s layout makes that placement clear. Removing it from Filters does not require deleting the source column.

Does adding a field to Filters change the source data?
No. It changes the PivotTable’s view of the source records; it does not delete or rewrite rows in the original range or table. Clear the filter or select All to view the items again.

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.