Excel Pivot Table: Use a Field as Row and Filter

Charts & pivot tables · Updated November 19, 2026

Yes. In an Excel PivotTable, you can place the same field in both the Rows and Filters areas. The field then appears as row labels, while a report filter above the PivotTable lets you choose which of its items to include.

What it means to use a field twice

A PivotTable divides fields into areas that determine how the summary is arranged. A field in Rows supplies labels down the side of the report. A field in Filters supplies a report-level dropdown, usually displayed above the PivotTable. Placing one field in both areas gives you both ways to work with it.

For example, putting Region in Rows can show East, West, and Central as separate row labels. Adding Region to Filters also creates a dropdown above the report. If you choose East in that dropdown, the PivotTable is limited to East, and the row labels show only the included region. The filter does not remove or edit records in the original source data; it changes what the PivotTable displays and summarizes.

This is useful when you want a field to remain visible in the report but also want a convenient control for selecting the scope of the report. It can be especially helpful when the row field is one level in a larger hierarchy, such as Region above Product, or Department above Employee.

How to add the same field to Rows and Filters

These steps apply to Excel for Microsoft 365 on Windows. Start with a PivotTable that has the field you want in its source data. If you have not created one, select a cell in the data and choose Insert > PivotTable, then complete the dialog to place the PivotTable in a new or existing worksheet.

  1. Click anywhere inside the PivotTable. The PivotTable tabs appear on the ribbon.
  2. Choose PivotTable Analyze > Field List if the PivotTable Fields pane is not already open.
  3. In the field list, drag the desired field name into the Rows area.
  4. Drag that same field name from the list again, this time into the Filters area.
  5. Use the dropdown above the PivotTable to select the item or items you want to display.

Drag the field name from the list at the top of the pane when adding the second copy. Dragging the existing field button out of the Rows area and into Filters will move it rather than keep it in both places. If the field is already in Rows, its checkbox may be selected; that does not prevent you from dragging its name into another area.

The order of fields within an area matters when you have more than one row field. For example, putting Region above Product groups products under each region; putting Product above Region reverses that hierarchy. A field in Filters is separate from that row-field order.

A concrete example with sales data

Suppose a source table has columns named Region, Product, and Sales, with one row for each sales record. Build a PivotTable with Region and Product in Rows and Sales in Values, summarized by Sum. The report lists products under regions and shows the sales total for each combination.

Now add Region to Filters as well. Choosing East in the report filter limits the PivotTable to sales records where Region is East. The row hierarchy will then contain East and its products, rather than all regions. Choosing multiple regions allows multiple branches of the report to appear. The grand total is recalculated from the included records; it is not necessarily the same as the total for the full source table.

This arrangement can be valuable when the report needs to show the selected value in its row structure, but the person reviewing it also needs a quick way to narrow or broaden the report. It can also make the selected scope more apparent than using only a row-label filter, because the report filter is displayed above the PivotTable.

How the report filter behaves

Click the dropdown beside the report-filter field name and choose an item. Excel then filters the PivotTable to records matching that selection. If you want to include several values, open the dropdown and select the Select Multiple Items option, then mark the values to include. The available choices depend on the distinct items in the field and on any other filters already applied.

A report filter affects the entire PivotTable, not just one row or one column. Every value field in the report is calculated from the records that remain in scope. If you add more than one field to Filters, each report filter can further narrow the data; selections work together, so the displayed records must satisfy all the active filters.

  • Choose a single item when you want a focused report, such as one region.
  • Choose multiple items when you need a combined view, such as East and Central.
  • Choose (All), or clear the filter using the dropdown, to return to all available items for that field.

Some PivotTable layouts or data sources may affect which choices are available or how items are listed. In particular, a field connected to an external or OLAP source can behave differently from a PivotTable built from a regular worksheet range. The basic idea remains the same, but source-specific options can differ.

Report filters versus row-label filters

A report filter and a row-label filter can both restrict the visible data, but they present the control in different places. The report filter sits above the PivotTable and applies to the report as a whole. A row-label filter is applied from the dropdown beside the row field inside the PivotTable. The latter is useful when readers should filter directly where they see the labels, or when they need options such as text, date, or value filtering available for that field.

Using the same field in both places does not create two independent versions of the underlying data. Both controls work on the same PivotTable field. If you make a selection in one control, the other may show only the remaining available items or otherwise reflect the restricted set. Avoid treating the two dropdowns as separate databases or separate copies of the field.

There is also a difference between filtering and sorting. Filtering hides items that do not meet the selection; sorting changes their order without excluding them. Likewise, adding a field to Rows does not automatically filter the source data. It organizes the summary, while the dropdown controls which items contribute to the displayed result.

Common problems and fixes

  • The field disappears from Rows. It was probably moved from the Rows area rather than added again from the field list. Drag its name from the list into Filters, then confirm the field remains in Rows.
  • The field list is missing. Click the PivotTable, then choose PivotTable Analyze > Field List. The pane can also be opened from the PivotTable context menu, depending on the Excel interface.
  • The field is not in the list. Check whether the column is part of the PivotTable source. If you added a source column after creating the PivotTable, use PivotTable Analyze > Change Data Source to include it, then refresh.
  • New items do not appear in the dropdown. Refresh the PivotTable with PivotTable Analyze > Refresh. If new source rows were added outside the original range, update the source range or use an Excel Table as the source so its structured range can expand as rows are added.
  • The filter does not show multiple choices. Open its dropdown and look for Select Multiple Items. If the PivotTable uses a connection or special source, selection behavior can be limited by that source.
  • The report is blank after filtering. Confirm that the selected items exist in the current source and that other active filters are not excluding them. Clear the report filter to test whether the underlying PivotTable still has data.

When a field contains empty cells, Excel may show a blank item in its filter list. That item represents records whose value for the field is empty; it is not necessarily a formatting problem. Check the source column if blank records should not be included.

Refreshing and keeping the report reliable

A PivotTable stores a summarized view of its source, so changes to source records generally do not appear until the PivotTable is refreshed. Use PivotTable Analyze > Refresh after editing the source. Refresh All on the Data tab can update multiple workbook connections and PivotTables, although the exact effect depends on the workbook’s sources.

If the source table gains a new category, such as a newly added region, refresh so Excel can update the field items. If the new category comes from rows added beyond a fixed source range, refresh alone may not include those rows. Check the source through PivotTable Analyze > Change Data Source and extend it as needed. Formatting the source as an Excel Table before creating a PivotTable is a practical way to make added rows easier to include.

On Excel for Mac, the field-list approach is substantially the same, although the ribbon and pane arrangement can differ by build. Excel for the web also supports PivotTables, but its available editing controls can vary. If a particular field-placement option is missing in the web interface, open the workbook in the desktop app.

When a slicer may be a better control

If a report filter works but is not easy for other people to notice, a slicer can offer a more visible selection interface. A slicer displays buttons for field items and can be connected to a PivotTable through the ribbon command for inserting a slicer. It takes up more worksheet space than a dropdown, but makes the current selection easier to see and can be more convenient during presentations or dashboard use.

A slicer is an alternative control, not a requirement for putting a field in both Rows and Filters. Choose the report-filter dropdown when compactness matters or the PivotTable is mainly for analysis. Consider a slicer when people need to interact with the report frequently or may overlook a small dropdown. The best choice depends on the report’s audience and layout.

Frequently Asked Questions

Can the same PivotTable field be in Rows and Filters at the same time?
Yes. Drag the field name from the field list into Rows, then drag it from the list again into Filters. The field will act as row labels and as a report filter.

Why does my field move instead of appearing twice?
You may be dragging the existing field button from one area to another. Drag the field name from the list at the top of the PivotTable Fields pane to add it to the second area.

Does the filter change my original Excel data?
No. A PivotTable filter changes which source records are included in the summary. It does not delete, edit, or hide the corresponding rows in the source worksheet.

Can I select more than one item in a report filter?
Usually, yes. Open the filter dropdown and select Select Multiple Items, then choose the values to include. Available behavior can depend on the PivotTable’s data source.

Can I use the field in Rows, Filters, and Columns too?
Excel allows fields to be arranged in PivotTable areas to shape the report, but a field’s usefulness and supported placement can depend on the source and layout. Add it from the field list and check that the resulting report is clear and accurate.

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.