Pivot Table Issues

How to Show Selected PivotTable Filter Items Instead of 'Multiple Items'

Maira Mehtab Oct 10, 2026 869 views

Question details

The user wants to display the exact items selected in a PivotTable filter rather than seeing the generic '(Multiple Items)' label.

How to Show Selected PivotTable Filter Items Instead of Multiple Items

Product: Spreadsheet Software
Device & OS: not provided
Scenario: Filtering data in a PivotTable using multiple criteria simultaneously.
Observed behavior: When selecting more than one item in a standard PivotTable drop-down filter, the cell automatically displays '(Multiple Items)', obscuring the actual applied filter criteria.

Before you start

Ensure your PivotTable is successfully connected to your source data and that your spreadsheet software supports advanced visual filtering tools.

Solution 1Recommended

Use a Slicer to Visually Display Selected Filter Items

Inserting a Slicer is the most effective and built-in way to replace the standard drop-down filter, allowing you to visually track exactly which items are currently active.

Standard PivotTable filters default to showing '(Multiple Items)' when more than one option is selected. While this behavior is hardcoded to save space on the worksheet, it unfortunately hides your specific active filters.

Using a Slicer resolves this by replacing the traditional drop-down filter with a visual, interactive button panel. Any item you select is highlighted, making it instantly clear which filters are applied to your PivotTable.

Select the PivotTable

Click anywhere inside your existing PivotTable to activate the PivotTable Tools menu on the top ribbon.

Insert a Slicer

Navigate to the 'Analyze' (or 'Options') tab on the ribbon and click on 'Insert Slicer' in the Filter group.

Choose the Filter Field

In the dialog box that appears, check the box next to the specific field you want to filter by, then click 'OK'.

Apply Multiple Filters

A visual Slicer panel will appear on your sheet. Click the buttons to filter your data. To select multiple items, hold down the 'Ctrl' key while clicking. The selected items will remain visibly highlighted in the panel.

Use a Slicer to Visually Display Selected Filter Items

Clearer Presentations: Slicers not only show your exact selections but also make it much faster to toggle filters on and off, which is highly beneficial when presenting data to an audience.

Powerful Data Analysis

Easily Manage PivotTable Filters with WPS Spreadsheet

WPS Spreadsheet offers fully featured PivotTables and intuitive Slicers, allowing you to filter data visually and avoid confusing '(Multiple Items)' labels without any complex workarounds.

1. Open Your Data: Launch WPS Spreadsheet and open the file containing your source data.
2. Create a PivotTable: Select your data range, go to the 'Insert' tab, and click 'PivotTable' to generate your report.
3. Add a Slicer: Click inside the newly created PivotTable, navigate to the 'PivotTable Analyze' tab, and click 'Insert Slicer' to visually manage your multiple selections.

Create dynamic PivotTables and charts with a single clickFully compatible with Microsoft Excel (.xlsx) formats and featuresBuilt-in interactive Slicers for crystal-clear data filteringFree, lightweight, and incredibly fast for large datasets

microsoft office alternative - wps office

Frequently Asked Questions

Can I force the traditional drop-down filter to list the selected items instead of '(Multiple Items)'?

No, the '(Multiple Items)' label is standard, hardcoded behavior in spreadsheet software when two or more items are selected in a standard report filter. Using a Slicer is the recommended built-in alternative.

Can I connect one Slicer to multiple PivotTables?

Yes. If your PivotTables are built from the same data source, you can right-click the Slicer, select 'Report Connections' (or 'PivotTable Connections'), and check the boxes for the other PivotTables you want to control simultaneously.

Why is the 'Insert Slicer' option grayed out in my spreadsheet?

The 'Insert Slicer' option may be disabled if your document is saved in an older file format (like .xls instead of .xlsx) or if you have selected a range outside of an active PivotTable or formatted Table.

Excel & Data Problems