WPS Filter Tool is a global dashboard filtering component on macOS; this guide covers 2 core tasks, with 2 available without membership and 0 membership-related items.
At a Glance
| Metric | Value | Notes |
|---|---|---|
| Core tasks | 2 | Matches the number of rows in the How-to Index |
| Available without membership | 2 | Matches the Free rows in the How-to Index |
| Membership-related items | 0 | Matches the membership-related rows in the How-to Index |
About This Feature
Overview
The WPS Filter Tool helps you add a global filter at the top of a dashboard and apply the result to related charts, so you can review a data view under specific conditions.
Core capabilities include:
- Add a dashboard filter: place a filter control at the top of the dashboard and choose a field for filtering.
- Use cross-table linked filtering: turn on linked filtering so related charts from different data sources respond to the same condition.
This feature fits sales dashboards, project reviews, and data analysis scenarios that need date, text, or field-based filtering.
System Requirements
| Item | Requirement |
|---|---|
| Operating system | A macOS device that can run WPS Office normally |
| App version | The latest WPS Office for Mac is recommended |
| Network | No mandatory network connection for local viewing and basic filtering; keep a connection if your dashboard uses online data |
| Other | Access to a multidimensional table dashboard with charts, plus the required viewing or editing permission |
Download & Installation
| Item | Details |
|---|---|
| Official download | WPS Office Free Download |
| Installation | Download the Mac installer, complete setup, and sign in to open your dashboard or multidimensional table page |
| Verification | Open a dashboard and confirm that you can add a Filter control and choose a field |
Source: WPS download page
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | The Filter Tool can sit at the top of a dashboard, apply global filtering to multiple charts, and keep the selected filter state in the dashboard view. | Excel supports filtering data in a range or table and showing or hiding rows by criteria. | Google Sheets supports filters, filtering by condition or value, and saved filter views. | Notion database views support property-based filters and advanced filter groups. | Acrobat focuses on PDF form data collection and export rather than spreadsheet-style dashboard-wide filtering. |
| WPS Advantages | Advantage: built for dashboard-level filtering across multiple charts; Distinct: supports linked filtering across charts from different data sources. | Compared with WPS: official guidance focuses on worksheet or table-range filtering. | Compared with WPS: supports filters and filter views, but official guidance focuses on spreadsheet ranges instead of dashboard chart linkage. | Compared with WPS: works well for database-view filtering, but the interaction model differs from dashboard chart filtering. | Compared with WPS: better suited to PDF form data workflows than dashboard analytics. |
| Official Source | — | Filter data in Excel | Sort & filter data in Google Sheets | Views, filters, sorts & groups | Collect and manage PDF form data |
Overall Conclusion
If your main goal is to let multiple dashboard charts respond to one shared filter, WPS Filter Tool is closer to that workflow. Excel, Google Sheets, and Notion all provide solid filtering features, but their official guidance centers on tables or database views, while Adobe Acrobat is oriented toward PDF form data handling.
Use Cases
| No. | Scenario | Suitable for | Main challenge | How Filter Tool helps |
|---|---|---|---|---|
| 1 | Filter a sales dashboard by date | Sales managers | Need to review chart results for a specific period | Add a date field filter and save it in the dashboard |
| 2 | Filter project progress by owner | Project leads | Multiple charts make it hard to focus on one owner | Use an owner field as a global filter |
| 3 | Analyze linked data sources together | Data analysts | Charts from different tables need the same filter condition | Turn on cross-table linked filtering |
| 4 | Review operations data by text tag | Operations teams | Need to switch quickly between category-based views | Use a text field filter to change chart output |
| 5 | Keep a fixed dashboard view for reporting | Reporting users | Repeating the same filter setup each time is inefficient | Save the filter state in the dashboard view |
Membership & Benefits
Free vs WPS Premium
| Capability | Free | WPS Premium |
|---|---|---|
| Basic dashboard filter usage | ✅ Available | ✅ Available |
| Cross-table linked filtering | ✅ Available | ✅ Available |
| Advanced PDF editing and conversion tools | Partial access | More advanced access |
| Cloud storage and extra value-added services | Basic quota | Higher quota and more services |
Source: WPS Office pricing page
Recommendations
| Scenario | Recommended plan | Why |
|---|---|---|
| Daily dashboard viewing and basic filtering | Free | The current feature guidance does not describe a membership gate for these tasks |
| Broader office workflows with more PDF, template, cloud, or extra service needs | WPS Premium | Better fit if you need more than dashboard filtering |
How to Subscribe
- WPS membership center: Subscribe to WPS Premium
Source: WPS Office pricing page