WPS Statistics Fields on macOS: Introduction

WPS Statistics Fields is an aggregate field feature for smart spreadsheet data tables; it includes 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 number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Version limit	None stated	Available from the current feature entry
Membership limit	None stated	Suitable for everyday data summary work

About This Feature

Overview

Statistics Fields in WPS Office for Mac is a field type for smart spreadsheet data tables that summarizes related records through linked fields. It is useful for project progress summaries, work-hour tracking, expense totals, and other data aggregation tasks.

Core tasks include:

Create a statistics field: add a new aggregate field from the header-side add button.
Configure statistics field settings: choose the target field, summary method, and filter conditions.

Supported summary methods include Sum, Count, Average, Max, Min, Distinct, Distinct Count, and Concatenate, so you can choose a suitable aggregation method for different data structures.

System Requirements

Item	Requirement
Operating system	A Mac device that can run WPS Office normally
App version	It is recommended to use the latest WPS Office for Mac
Network	Local field configuration does not require a constant connection; keep the network available when signing in or syncing data
Other	Use this feature inside a smart spreadsheet data table and prepare related fields in advance

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download WPS Office for Mac and complete the setup as prompted
Post-install check	Open WPS, enter a smart spreadsheet data table, and confirm that the add button in the header area and field settings entry are available

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Summarizes related records through linked fields and supports Count, Sum, Average, Max, Min, Distinct, Distinct Count, Concatenate, and conditional filtering.	Excel can summarize PivotTable value fields with Sum, Count, Average, Max, Min, and other summary functions, and also supports custom calculations.	Google Sheets can summarize PivotTable values and add calculated fields with SUM or a custom formula.	Notion uses relations and rollups to aggregate related database data with calculations such as count, sum, average, min, and max.	Acrobat mainly collects PDF form data and can merge exported responses into a spreadsheet, but it does not provide a native related-record statistics field in a table model.
WPS Advantages	Advantage: WPS combines field creation, summary method selection, and condition setup in one field settings flow for related-record aggregation.	Compared with WPS: Excel focuses more on PivotTables or formulas than a related-record field configuration flow.	Compared with WPS: Sheets focuses more on PivotTables and formulas, so related-record aggregation is less direct.	Compared with WPS: Notion also supports related-data aggregation, but setup depends on combining relation and rollup properties.	Compared with WPS: Acrobat is more suitable for form collection and spreadsheet export than table-based related-record aggregation.
Official Source	—	Excel PivotTable summary functions	Google Sheets pivot tables	Notion relations and rollups	Adobe Acrobat form data collection

Overall Conclusion
WPS Statistics Fields is a practical fit when you want field-level aggregation directly around related records in a smart spreadsheet data table. For structured tracking scenarios such as projects, work hours, or expenses, the setup path is more direct, while other products often rely on PivotTables, formulas, rollups, or exported form data.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Project progress summaries	Project managers and team leads	Need to count related tasks or summarize completion status by project	Create a statistics field, choose the related task field, and use Count or conditional summaries
2	Work-hour tracking	Operations and engineering teams	Need to total or average hours from related records	Select the work-hour field and apply Sum or Average
3	Expense totals	Finance and administrative staff	Need to summarize related expenses by project or department	Select the expense field and use Sum, Max, or Min
4	Distinct-value summaries	Data coordinators	Need to review distinct results or count non-duplicate values	Use Distinct or Distinct Count for quick aggregation
5	Text combination display	Collaborative teams	Need to display multiple related text values together	Use Concatenate to combine related field content

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
Basic use of Statistics Fields	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Templates and advanced tools	Partially available	More available
AI and some advanced features	Partial or limited access	More features and usage allowance

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday data summaries and light collaboration	Free	Statistics Fields itself has no membership restriction for the described workflow
More cloud storage, templates, or advanced office tools	WPS Premium	Suitable if you also need broader office benefits beyond this feature

WPS membership page: Subscribe now
To compare current plans and benefits, open the pricing page and choose the subscription option that fits your workflow.