Create New Pivot Table in WPS on Windows: Introduction

Create New Pivot Table in WPS on Windows is a spreadsheet analysis feature for summarizing source data; this guide covers 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 in WPS on Windows is a built-in spreadsheet feature for turning an existing data range into a summary report and reviewing the same dataset from different perspectives by arranging fields.

Core capabilities include:

Create a PivotTable from a selected data range for sales, inventory, project, or reporting data.
Choose where to place the PivotTable in a new worksheet or an existing worksheet.
Arrange fields in Page, Column, Row, and Data areas.
Adjust field layout or delete an inserted PivotTable when needed.

This feature is useful for sales summaries, department reports, project tracking, and recurring data reviews. It helps reduce manual summarizing work and makes it easier to compare the same dataset across different dimensions.

Source: How to make a PivotTable in WPS Spreadsheets

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local PivotTable creation; internet access is needed for download, sign-in, or cloud file scenarios
Other	A usable worksheet data range with clear headers is recommended

Download & Installation

Item	Details
Official download	WPS Office Free Download
Post-install check	Open WPS Spreadsheet, load a worksheet with data, and confirm that the PivotTable entry is available on the Insert tab

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Create a PivotTable from a selected data range, place it in a new or existing worksheet, and drag fields into Page, Column, Row, and Data areas.	Excel lets you create a PivotTable from a table or range, place it in a new or existing worksheet, and configure fields in the PivotTable Fields pane.	Google Sheets lets you insert a pivot table and add Rows, Columns, Values, and filters from a side panel.	Notion focuses on creating databases and multiple views for structured information, but it is not a cell-based PivotTable workflow.	Adobe Acrobat focuses on collecting PDF form data and exporting it to spreadsheet or XML formats rather than creating native spreadsheet PivotTables.
WPS Advantages	Advantage: stays inside the spreadsheet workflow for source selection, placement, and field arrangement. Distinct: after creation, fields can be moved directly to compare different summary views.	Compared with WPS: offers a similar PivotTable workflow with field panes and worksheet placement options.	Compared with WPS: offers browser-based pivot tables with side-panel editing and collaboration-oriented workflows.	Compared with WPS: centers on database views instead of worksheet-style PivotTable summaries.	Compared with WPS: centers on PDF data collection and export, not native spreadsheet PivotTable analysis.
Official Source	—	Create a PivotTable in Excel	Create and use pivot tables in Google Sheets	Create a database in Notion	Collect and manage PDF form data in Acrobat

Overall Conclusion
For worksheet-based summary analysis, WPS, Excel, and Google Sheets all provide direct PivotTable workflows. Notion is better aligned with database views, and Adobe Acrobat is better aligned with PDF form collection and export. For users who want to build and adjust PivotTable summaries inside a spreadsheet window, WPS fits that workflow directly.

Use Cases

No.	Scenario	Suitable for	Main challenge	How this feature helps
1	Sales summary analysis	Sales and operations teams	Large raw datasets take time to summarize manually	Create a PivotTable from sales details and summarize by product, region, or month
2	Inventory review	Warehouse and purchasing teams	Quantities need to be checked by category or location	Move fields into row and column areas for quick category-based summaries
3	Project tracking review	Project managers and team leads	The same data needs to be reviewed from different angles	Rearrange fields to switch between department, stage, or owner views
4	Weekly or monthly reporting	Admin, finance, and managers	Repeated summary reports take time to rebuild	Place the PivotTable in a new worksheet as a dedicated summary sheet
5	Data verification	Analysts and assistants	Summary results need cross-checking	Recombine fields in different areas to verify totals and structure

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
Create a new PivotTable	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Cloud storage	1 GB	20 GB or more depending on the plan shown on the page
Templates and advanced tools	Some limits apply	More advanced tools and higher quotas are available
AI-related tools	Some limits apply	Broader access and higher usage limits are available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Everyday PivotTable creation and review	Free	The PivotTable feature itself is available for regular spreadsheet summarizing
More cloud storage, templates, or broader office tools	WPS Premium	Better suited to long-term multi-file, cross-device, or expanded office workflows
Shared subscription for multiple people	Sharing Plan	Suitable when multiple users need separate accounts and storage under one plan

Membership page: Subscribe to WPS Premium