WPS Categorical Summary on macOS: Introduction

WPS Categorical Summary on macOS helps you group worksheet data by a selected field and generate summary results; this guide covers 3 core tasks, with 3 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	3	Matches the number of rows in the How-to Index
Available without membership	3	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index

About This Feature

Overview

Categorical Summary in WPS Spreadsheets for macOS is a built-in data summarization feature for grouping a continuous data range by a selected field and generating structured summary results with outline levels.

Core capabilities include:

Create a single-level summary: group data by one field and calculate Sum, Count, Average, Max, Min, and similar results.
Create nested multi-level summaries: add another grouping level on top of an existing summary structure.
Remove a summary: clear the current summary structure and return to the original detail view.

This feature is useful for department reports, sales summaries, and project data reviews when you need to check grouped results more efficiently in WPS Office on macOS.

System Requirements

Item	Requirement
Operating system	A macOS device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office for Mac
Network	Categorical Summary is a local spreadsheet feature and does not require a constant internet connection during use
Other	The data range should be a continuous rectangular area with a header row, and merged cells are not recommended

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-installation check	Open WPS Spreadsheets, then confirm that the Categorical Summary entry is available on the Data tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Provides a Categorical Summary command that groups data by a selected field and supports summary methods such as Sum, Count, Average, Max, and Min, with outline-style grouped results.	Excel provides the Subtotal command to calculate subtotals and grand totals, supports nested subtotal levels, and adds outline controls for showing or hiding detail rows.	Google Sheets mainly uses pivot tables for grouped summaries, with rows, columns, values, and summary settings configured in the pivot table editor.	Notion table databases support column calculations such as Sum, Average, Min, Max, and Count, but the workflow is centered on database properties rather than a spreadsheet subtotal command.	Adobe Acrobat provides AI-generated summaries for PDF documents, but its official help content does not describe a spreadsheet-style grouped subtotal feature.
WPS Advantages	Advantage: offers a direct command on the Data tab for grouped worksheet summaries; Distinct: supports single-level summaries, nested summaries, and removing the summary structure in one workflow.	Compared with WPS: Excel offers a similar subtotal workflow, but Microsoft notes that subtotals are not supported in Excel tables unless the table is converted to a normal range first.	Compared with WPS: Google Sheets relies more on pivot tables for similar grouped analysis, so the setup path and result presentation differ from a direct subtotal command.	Compared with WPS: Notion is more suitable for database-style information management and column calculations than for traditional spreadsheet subtotal commands.	Compared with WPS: Adobe focuses on PDF reading and AI summaries rather than grouped spreadsheet statistics.
Official Source	—	Insert subtotals in a list of data in a worksheet	Create & use pivot tables	Table view	Get AI-generated summaries

Overall Conclusion
If your main goal is to group worksheet data by field and generate structured summary rows, WPS provides a workflow that is close to traditional spreadsheet subtotal operations. Microsoft Excel also offers a comparable subtotal path, while Google Sheets and Notion usually approach similar analysis through pivot tables or database calculations instead of a direct subtotal command.

Use Cases

No.	Scenario	Suitable for	Main challenge	Suggested solution
1	Department expense summaries	Admin and finance teams	Too many detail rows to total manually by department	Create a summary by the Department field
2	Sales data grouping	Sales and operations teams	Need to review grouped sales results quickly	Choose a summary method and select the columns to summarize
3	Multi-level business analysis	Managers and analysts	Need to review data by major and minor categories	Create nested multi-level summaries
4	Restoring the original view	Spreadsheet editors	Need to return from a summary view to the original detail list	Use Remove All to clear the summary
5	Recurring report preparation	Team members handling regular reports	Repeating the same grouping steps takes time	Reuse the summary workflow to build reports faster

Membership & Benefits

Free vs WPS Premium

The feature content for this workflow indicates that Categorical Summary on macOS is available without a membership requirement. The WPS Office pricing page also shows a free plan and paid plans with broader office, PDF, cloud, and AI-related benefits.

Capability	Free users	WPS Premium
Categorical Summary	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Additional advanced office features	Depends on the feature shown in the product	Usually includes broader feature access
Cloud storage and extra benefits	Basic benefits	Varies by plan

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Everyday grouped summaries and basic spreadsheet work	Free plan	This feature is available directly and fits routine spreadsheet organization
Broader office, PDF, cloud, or AI needs	WPS Premium	Suitable when you also need more advanced tools and additional plan benefits

WPS membership center: Subscribe now