How to Capture Slicer Selections from a Regular Excel Table in WPS Spreadsheets
Question details
The user needs to display the item or items selected by a slicer that is connected to a regular Excel table, without using GETPIVOTDATA because no PivotTable is present.

- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- A user has a regular Excel table with a slicer and wants to show the currently selected slicer item or items in a cell for reports or dashboards.
- Observed behavior
- GETPIVOTDATA is not available because the slicer is not connected to a PivotTable, so a helper-column formula is required to identify visible rows and combine their values.
Make sure your data is formatted as an Excel table and the slicer is connected to that table. Check that your WPS Spreadsheets version supports the FILTER and TEXTJOIN functions before creating the helper column.
Capture slicer selections with a SUBTOTAL helper column and TEXTJOIN/FILTER
Use this method in WPS Spreadsheets versions that support FILTER and TEXTJOIN; it updates automatically when the slicer changes and preserves duplicates row by row.
Because the slicer is connected to a regular table rather than a PivotTable, GETPIVOTDATA cannot retrieve the selected items. A helper column uses SUBTOTAL(103,...) to mark only the rows currently visible after the slicer filters the table. Then FILTER returns the visible item values and TEXTJOIN combines them into one list.
Select the first empty cell in a new column inside the table, type =SUBTOTAL(103,[@Item]) in the formula bar, and press Enter. Replace [@Item] with the column that contains your slicer values if it is named differently.
Click the existing slicer, or go to Table Tools > Insert Slicer, choose the Item column, and then click different slicer buttons. Visible rows display 1 in the helper column while hidden rows display 0.
Click an empty cell, enter =TEXTJOIN(", ",TRUE,FILTER(Table1[Item],Table1[Visible]=1)) in the formula bar, and press Enter. Adjust Table1, Item, and Visible to match your table names.
Select different slicer buttons and confirm that the result cell updates immediately to show the currently selected item or items as a comma-separated list.

Use an IF/COUNTIF helper column and TEXTJOIN for older WPS versions
Use this fallback when FILTER is not available; it creates a helper column that returns selected values and then combines them with TEXTJOIN.
Capture table slicer selections in WPS Spreadsheets
WPS Spreadsheets can capture slicer selections from a regular Excel table without GETPIVOTDATA. Add a SUBTOTAL helper column to mark visible rows, then use FILTER and TEXTJOIN to return a clean, comma-separated list that updates with the slicer.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, open the .xlsx or .xls file that contains the table and slicer, and click the worksheet tab with the table.
- 2. Add the Visible helper column: Click the first empty cell in a new table column, type =SUBTOTAL(103,[@Item]) in the formula bar, and press Enter.
- 3. Enter the TEXTJOIN/FILTER result formula: Select an empty cell, enter =TEXTJOIN(", ",TRUE,FILTER(Table1[Item],Table1[Visible]=1)), and press Enter.
- 4. Test the slicer selection: Click different buttons in the slicer and confirm that the result cell updates to show the currently selected item or items.

Frequently Asked Questions
Why doesn’t GETPIVOTDATA work for a regular table slicer?
GETPIVOTDATA only returns values from a PivotTable. When a slicer is connected directly to an Excel table, there is no PivotTable context, so use a helper column with SUBTOTAL(103,[@Item]) and combine visible values with FILTER and TEXTJOIN.
Which WPS Spreadsheets functions do I need to capture slicer selections?
Use SUBTOTAL(103,[@Item]) to mark visible rows, FILTER to return only those rows, and TEXTJOIN to combine the values. FILTER is available in newer WPS Spreadsheets versions.
How do I handle duplicate items in the slicer source table?
The SUBTOTAL helper method returns duplicate items once per visible row. If you need a unique list, wrap the FILTER result with UNIQUE when supported, or use a separate dedupe step.
Will the captured selection update automatically when I click a different slicer button?
Yes. SUBTOTAL recalculates after the table is filtered by the slicer, and FILTER/TEXTJOIN update the result cell immediately.




