WPS Spreadsheets: Use Search to Filter PivotTable Report Filters
Question details
The user needs to filter items in a PivotTable field placed in the Filters area by searching for matching labels.
- Product
- WPS Spreadsheets PivotTable
- Device & OS
- not provided
- Scenario
- A PivotTable field is being used as a report filter, and the user wants to narrow its available items with text or wildcard searches.
- Observed behavior
- Fields in the Filters area provide item selection and a Search box, but they do not generally display the complete Label Filter menu available for fields in the Rows or Columns area.
Open the PivotTable and confirm that the field you want to filter is listed in the Filters area. Identify a sample item or text pattern so you can test the Search box and wildcard behavior.
Search the PivotTable report filter with a wildcard pattern
Use this method when the field is already in the Filters area and you need to narrow its item list by matching text.
The Filters area supports item selection and search. Wildcard patterns can match labels by position: use *e for items ending in e and e* for items beginning with e.
Click the drop-down arrow for the PivotTable field in the Filters area.
Click inside the Search box in the report filter list.
Type a search pattern such as *e to find items ending with the letter e, or e* to find items beginning with e.
Review the narrowed item list, select the required item or items, and click OK or Apply to update the PivotTable.
Move the field to Rows or Columns for advanced label filters
Use this option when you need more than item search, such as a full Label Filter menu with conditions like Begins With or Contains.
Filter PivotTable Items Faster with WPS Spreadsheets
WPS Spreadsheets lets you search PivotTable report-filter items with wildcard patterns and apply focused selections without manually browsing a long list. For advanced label conditions, move the field to Rows or Columns and use the Label Filter menu.
- 1. Open the workbook: Launch WPS Office, choose Spreadsheets, and open the workbook containing the PivotTable.
- 2. Select the PivotTable field: Click the PivotTable and locate the target field in the Filters area of the PivotTable Fields pane.
- 3. Search the filter items: Open the field's filter drop-down, click the Search box, and enter a text or wildcard pattern such as *e.
- 4. Apply the selection: Choose the matching item or items and click OK or Apply to refresh the PivotTable.
Frequently Asked Questions
Can I use wildcards in a WPS Spreadsheets PivotTable report filter?
Yes. Open the field drop-down in the Filters area, click the Search box, and enter a pattern such as *e for labels ending in e or e* for labels beginning with e.
Why do I not see the full Label Filter menu in the report filter?
A field in the Filters area generally supports item selection and search rather than the full Label Filter menu. Move the field to Rows or Columns to access conditions such as Begins With or Contains.
How do I filter PivotTable items that contain specific text?
Use the Search box in the report filter to narrow the item list, then select the matching items. For a formal Contains condition, move the field to Rows or Columns and choose Label Filter > Contains.
Does the Search box filter the PivotTable data immediately?
The Search box narrows the available item list. Select the desired results and confirm with OK or Apply to update the PivotTable report filter.
