WPS Statistics Fields on macOS: Introduction

WPS Statistics Fields is a related-record aggregation feature in WPS on macOS; 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 specified	No version gate is described for this feature

About This Feature

Overview

Statistics Fields is a field type in WPS multidimensional tables on macOS. It is used to automatically aggregate data from related records through relation fields, helping you summarize linked data without repeated manual calculations.

Core tasks include:

Create a statistics field: add a new field from the field creation entry on the right side of the table header.
Configure statistics field settings: choose the field to aggregate and set the calculation method, including sum, count, average, maximum, minimum, deduplication, deduplicated count, and string concatenation.

This feature fits scenarios such as task progress summaries, work-hour tracking, and expense totals. It helps reduce repeated setup for cross-table summaries and keeps aggregation settings easier to maintain inside the same multidimensional table.

System Requirements

Item	Requirement
Operating system	A macOS environment supported by WPS Office for Mac
App version	The latest version of WPS Office for Mac is recommended
Network	Internet is recommended for download, installation, sign-in, and online collaboration; local field configuration does not require a constant connection
Other	You need access to a multidimensional table and permission to edit field structure

Source: WPS Office Tech Specs

Download & Installation

Before using Statistics Fields, install WPS Office for Mac and make sure you can open a multidimensional table normally.

Item	Details
Official download	WPS Office Free Download
Installation method	Download the Mac installer package and complete the setup flow
Check after installation	Open WPS, enter a multidimensional table, and confirm that the add-field entry is available on the right side of the table header

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Statistics Fields aggregates related records through relation fields and supports count, sum, average, maximum, minimum, deduplication, deduplicated count, and string concatenation.	Excel supports aggregations such as AVERAGE, COUNT, DISTINCTCOUNT, MAX, MIN, and SUM in Power Pivot for related data models.	Google Sheets supports quick sum, average, and count on selected cells, along with standard functions such as SUM, AVERAGE, and COUNT.	Notion supports relation-based rollups across connected databases, including count, sum, average, min, and max.	Adobe Acrobat focuses more on PDF form calculations, where totals and averages can be built with scripts or form logic rather than relation-based table rollups.
WPS Advantages	Distinct: WPS places related-record aggregation directly at the field level in a multidimensional table, so you can create the field and adjust its calculation settings in one workflow.	Compared with WPS: Excel aggregation is more tied to data models, measures, and spreadsheet analysis workflows.	Compared with WPS: Google Sheets documentation here focuses on cell-range calculations rather than field-level aggregation for related records in a multidimensional table.	Compared with WPS: Notion also supports relation-based aggregation, but it is centered on database property setup.	Compared with WPS: Adobe is better aligned with PDF form calculations than with multidimensional table relation rollups.
Official Source	—	Aggregations in Power Pivot	See the sum & average	Relations & rollups	Custom calculations in PDF forms

Overall Conclusion
If you want to build related-record summaries directly inside a multidimensional table on macOS, WPS keeps the workflow close to field creation and field settings. Other products also support aggregation, but they emphasize spreadsheet models, database properties, or PDF form calculations in different ways.

Use Cases

No.	Scenario	Suitable For	Main Need	How Statistics Fields Helps
1	Task progress summary	Project managers and team leads	Linked task data needs a quick summary	Create a statistics field to aggregate related task records
2	Work-hour tracking	Operations and delivery teams	Hours are stored across related records	Select the hour field and use sum or average
3	Expense totals	Finance collaborators and business owners	Related expense records need one total view	Aggregate amount fields with sum or maximum
4	Deduplicated summaries	Data administrators	Repeated values affect summary results	Use deduplication or deduplicated count
5	Text aggregation	Cross-functional teams	Related text values need one combined view	Use string concatenation to combine related text

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Create and configure Statistics Fields	Available	Available
Basic multidimensional table editing	Available	Available
Other premium benefits across WPS	Depends on the current account benefits page	More value-added benefits may be available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
Daily use of Statistics Fields and basic table collaboration	Free	This feature is described without a membership limit
Broader office use with more value-added benefits	WPS Premium	Suitable if you also need additional benefits across WPS products

Subscribe here: Get WPS Premium