PIVOTBY in WPS on Windows: Introduction

PIVOTBY in WPS on Windows is a spreadsheet function for data calculation and analysis; 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
Version limits	None	Available in AirSheet across supported versions

About This Feature

Overview

PIVOTBY in WPS on Windows is a function in AirSheet for data calculation and analysis. After you enter the function, you can complete different calculation tasks with its parameters, and the result updates automatically when the source data changes.

Core capabilities include:

Enter the PIVOTBY function quickly for everyday spreadsheet analysis.
Follow syntax prompts to fill in parameters for different calculation scenarios.
Use cross-sheet references and nested calculations for more complex formulas.
Keep results updated automatically after data changes.

System Requirements

Item	Requirement
OS	A Windows device that can run the current version of WPS Office normally
App version	The latest version of WPS Office is recommended; the function is available in AirSheet across supported versions
Network	No mandatory internet connection is required for local formula entry and calculation; internet access is needed for download, installation, and account-related actions
Other	You need to be able to open an AirSheet file and edit cells and formulas

Download & Installation

Item	Details
Official Download	WPS Office Free Download
Post-install Check	Open WPS Office, open AirSheet, select any cell, and type `=PIVOTBY(` to confirm that the function entry point and syntax prompt are available

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	In AirSheet, you can type `=PIVOTBY(` directly and use syntax prompts, cross-sheet references, nested calculations, and automatic recalculation.	Word supports formulas in table cells and lets users update results, but the workflow is centered on document tables rather than a spreadsheet formula editor.	The Google Docs product page highlights online document creation and collaboration, but it does not describe a spreadsheet-style formula entry workflow inside Docs.	Notion formulas can perform calculations with database properties, built-ins, and functions, mainly for database property logic.	Acrobat can configure calculations for PDF form fields so results change when form input changes.
WPS Advantages	Advantage: Built for direct spreadsheet formula entry in AirSheet. Distinct: It combines syntax prompts, cross-sheet references, nested calculations, and automatic recalculation in one worksheet workflow.	Compared with WPS: formula support is focused on Word table cells, not a full spreadsheet-style function editing flow.	Compared with WPS: the official page emphasizes collaborative documents instead of a comparable worksheet formula entry experience.	Compared with WPS: formulas are mainly tied to database properties rather than cell-based spreadsheet editing.	Compared with WPS: calculations are mainly designed for PDF form fields rather than spreadsheet analysis.
Official Source	—	Use a formula in a Word table	Google Docs product page	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion
PIVOTBY is a practical fit when you need a worksheet formula workflow on Windows for data calculation and analysis. If your work depends on entering formulas in cells, adjusting parameters, and seeing recalculated results after data changes, WPS is closer to that spreadsheet use case than document, database, or PDF form workflows.

Use Cases

#	Scenario	Target Users	Core Pain Point	Solution
1	Daily data summaries	Office users	They need to complete calculations quickly in a worksheet	Enter PIVOTBY in a cell and fill in parameters with the on-screen prompt
2	Multi-sheet data linkage	Data organizers	They need to use data from another worksheet in the same calculation	Build the formula with cross-sheet references
3	Complex formula combinations	Advanced spreadsheet users	A single function may not cover the full analysis logic	Nest PIVOTBY with other functions
4	Dynamic result updates	Users who maintain recurring reports	They need results to stay current after source data changes	Use automatic recalculation to reduce manual updates

Membership & Benefits

Free vs WPS Premium

Feature	Free User	WPS Member
PIVOTBY function usage	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More available

Source: WPS Office pricing page

Recommendations

Use Case	Recommended Plan	Reason
You mainly use PIVOTBY for everyday calculations	Free	The feature information shows no membership restriction for this function
You also need more cloud storage or additional office benefits	WPS Member	This is a better fit when you need expanded storage and more features beyond the function itself

WPS membership center: Subscribe now