Create New Pivot Table in WPS on macOS: Introduction

WPS Create New Pivot Table on macOS helps you summarize and analyze worksheet data; it includes 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	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

Create New Pivot Table is a spreadsheet feature in WPS for macOS that helps you build a summary view from an existing data range. After the PivotTable is created, you can place it in a new worksheet and continue adding row, column, and value fields for analysis.

Core capabilities include:

Start a new PivotTable from the current data range.
Select the source range and confirm where the PivotTable will be created.
Generate a PivotTable layout in a new worksheet.
Add fields to begin basic summary analysis.

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	No mandatory internet connection is required for local PivotTable creation; internet access is needed for download, installation, and account-related actions
Other	Prepare a usable worksheet data range, preferably organized by columns with headers

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheet, load your data file, and confirm that a PivotTable creation entry is available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Create a new PivotTable from worksheet data and continue configuring fields in a new worksheet for summary analysis.	Excel supports creating a PivotTable from a table or range and placing it in a new or existing worksheet.	Google Sheets supports Insert > Pivot table and lets you add rows, columns, and values in a side panel.	Notion provides database table views, grouping, and calculations, but not a native spreadsheet PivotTable workflow.	Adobe Acrobat focuses on PDF creation and conversion workflows rather than native spreadsheet PivotTables.
WPS Advantages	Advantage: It keeps PivotTable creation inside the spreadsheet workflow so you can continue editing and analyzing the source data in one place.	Compared with WPS: It also supports native PivotTables, with workflow centered on Excel worksheets.	Compared with WPS: It also supports pivot tables, with setup mainly handled in a web-based side panel.	Compared with WPS: It is better suited to database-style records and views than cell-based pivot summarization.	Compared with WPS: It is designed for PDF tasks, not spreadsheet pivot analysis.
Official Source	—	Create a PivotTable in Excel	Create and use pivot tables in Google Sheets	Notion table view	Adobe Acrobat PDF creation overview

Overall Conclusion
If you want to summarize and analyze data directly in a spreadsheet, WPS, Excel, and Google Sheets are the closest matches. Notion is more suitable for database-style organization, while Adobe Acrobat is focused on PDF workflows, so WPS is more directly aligned with creating a new PivotTable.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Sales data summaries	Sales teams, operations teams	Large detail tables make category-level results hard to review quickly	Create a PivotTable to summarize by region, product, or salesperson
2	Financial category analysis	Finance staff, accountants	Raw transaction records are difficult to turn into summary views	Use a PivotTable to summarize by account or month
3	Project progress review	Project managers, team leads	Task records are scattered and hard to review by owner or status	Build a PivotTable to group progress by field
4	Grade analysis	Teachers, school staff	Detailed score sheets are hard to compare by class or subject	Create a PivotTable to summarize by class or subject
5	Inventory review	Warehouse staff, purchasing teams	Inventory records are difficult to summarize by category or location	Use a PivotTable to summarize by warehouse or item category

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Create a new PivotTable	Available	Available
Basic spreadsheet editing	Available	Available
Some advanced value-added features	May be limited	More value-added features may be available
Cloud space and some extended services	Basic allocation	Higher allocation or more services

Source: WPS Office pricing page

Recommendations

Usage scenario	Recommended plan	Why
Occasional PivotTable creation and basic summaries	Free	Suitable for creating and using basic PivotTable analysis
Frequent document work with broader value-added needs	WPS Premium	Better suited to longer-term office work and extended services

Membership page: Subscribe to WPS Premium