WPS Statistics Fields on Windows: Introduction

WPS Statistics Fields is an aggregation feature in DBSheet; 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	All current topics are available directly

About This Feature

Overview

Statistics Fields helps you aggregate data from related records through relation fields in DBSheet. It supports count, sum, average, maximum, minimum, deduplication, distinct count, and string concatenation.

Core tasks include:

Create a statistics field: add a new field from the right side of the header row and choose the statistics type.
Configure statistics field settings: specify the field to aggregate, the calculation method, and the filter conditions.

This feature works well for project progress summaries, time tracking totals, expense rollups, and other spreadsheet aggregation workflows that need related-record calculations in one place.

System Requirements

Item	Requirement
OS	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	An internet connection is recommended when opening or syncing online DBSheet files
Other	You need access to the workspace that contains the DBSheet and permission to edit fields

Download & Installation

Before using Statistics Fields, install WPS Office for Windows and sign in with an account that can access your DBSheet files.

Item	Notes
Official Download	WPS Office Free Download
Post-install Check	Launch WPS Office, open a DBSheet, and confirm that the add-field entry is visible on the right side of the header row

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In DBSheet, Statistics Fields can aggregate related records through relation fields and support count, sum, average, maximum, minimum, deduplication, distinct count, string concatenation, and filter conditions.	Excel can aggregate one or more columns from a related table in Power Query and supports functions such as Sum and Average.	Google Sheets supports subtotal aggregation for vertical ranges with functions such as AVERAGE, COUNT, MAX, MIN, and SUM.	Notion relations and rollups can pull properties from related databases and summarize related values.	Acrobat mainly supports merging completed form data into a spreadsheet rather than configuring spreadsheet-style related-field aggregation.
WPS Advantages	Advantage: WPS keeps the statistics field, calculation method, and filter conditions in one field settings panel, which is convenient for related-record summaries in a spreadsheet workflow.	Compared with WPS: Excel often relies on Power Query or data-model steps for related-table aggregation.	Compared with WPS: Google Sheets focuses more on formulas or range-based summaries than related-record field configuration.	Compared with WPS: Notion supports relation summaries, but its database model is different from a traditional spreadsheet grid.	Compared with WPS: Adobe's official workflow is centered more on form-data export than spreadsheet field aggregation.
Official Source	—	Aggregate data from a column in Excel	SUBTOTAL in Google Sheets	Relations & rollups in Notion	Work with form data in Acrobat

Overall Conclusion: If you want to summarize related records directly inside a spreadsheet-style database, WPS offers a more concentrated setup path. Excel, Google Sheets, and Notion also provide summary features, but their entry points and data models differ. Adobe is better aligned with PDF form data collection workflows.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Project task summary	Project managers	They need to quickly review the number and progress of tasks linked to each project	Create a statistics field and use count or average
2	Time tracking totals	Team leads	They need to total member work hours from related records	Use sum in field settings and select the work-hour field
3	Expense rollups	Finance or operations staff	They need to total expenses by project or customer	Use a statistics field to sum the related expense field
4	Conditional data summaries	Data maintainers	They only want to count records that meet specific conditions	Add filter conditions in the statistics field settings
5	Deduplicated tag display	Collaborative teams	Related records contain repeated text values	Use deduplication or string concatenation to organize the result

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
Create statistics fields	✅ Available	✅ Available
Set calculation methods and filter conditions	✅ Available	✅ Available
Other membership services	Depends on the account plan	Additional membership services depend on the subscribed plan

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
Everyday DBSheet summaries	Free	This feature currently has no membership restriction, so you can create and configure statistics fields directly
Teams or individuals already using other membership services	WPS Premium	Suitable when you want to manage this feature together with other subscribed services

WPS membership center: Subscribe now