PIVOTBY in WPS on Windows is a built-in spreadsheet function for entering, reviewing, and troubleshooting formulas; it includes 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 table |
| Membership-related items | 0 | Matches the number of membership-related rows in the index table |
About This Feature
Overview
PIVOTBY is a built-in function in WPS Sheets for data processing and calculation. You can search for and insert the function from the Insert Function dialog box, type the formula directly in a cell or in the formula bar, and review the function syntax and parameter details when checking your formula.
Core tasks include:
- Search for and insert PIVOTBY from the Insert Function dialog box.
- Type
=PIVOTBY(...)directly in a cell or in the formula bar. - Review the function syntax, parameter details, and help entry.
System Requirements
| Item | Requirement |
|---|---|
| OS | A Windows PC that can run WPS Office normally |
| App version | The latest version of WPS Office is recommended |
| Network | No required internet connection for local formula entry; internet access is needed for online help or software download |
| Other | You need to open WPS Sheets and edit worksheet cells |
Download & Installation
| Item | Details |
|---|---|
| Official Download | WPS Office Free Download |
| Post-install Check | Launch WPS Sheets, open any worksheet, and confirm that the Formulas tab, formula bar, and Insert Function entry are available |
Source: WPS Download Center
Compare with Alternatives
| Dimension | WPS | Microsoft | Notion | Adobe | |
|---|---|---|---|---|---|
| Capability Summary | In WPS Sheets, you can use spreadsheet functions such as PIVOTBY through Insert Function, direct formula entry, and function help. | Microsoft Word supports formulas in table cells and lets users choose functions and number formats in the Formula dialog box, but the scenario is document-table calculation. | Google Sheets provides a full function list and supports cell formulas for strings, numbers, and data calculations. | Notion formulas are mainly used for database property calculations with properties, built-ins, and functions. | Adobe Acrobat can configure calculations for PDF form fields and is suited to linked form-field calculations. |
| WPS Advantages | Advantage: It is designed for spreadsheet cell formula entry, with both direct typing and dialog-based insertion plus syntax review in one workflow. | Compared with WPS: Formula support is centered on Word document tables, so it is not a full spreadsheet-style function entry environment. | Compared with WPS: It also supports many spreadsheet functions; WPS is more convenient for desktop local editing within an integrated office suite workflow. | Compared with WPS: It is more suitable for database properties and project-management formulas rather than traditional worksheet cell formula entry. | Compared with WPS: It focuses on PDF form field calculations rather than standard spreadsheet formula editing. |
| Official Source | — | Use a formula in a Word table | Google Sheets function list | Intro to formulas | Configure form field calculations in Acrobat |
Overall Conclusion
If your main task is entering spreadsheet functions, filling in parameters, and checking formulas, WPS Sheets fits everyday spreadsheet work more directly. Other products also provide calculation features, but they focus on document tables, online spreadsheets, database properties, or PDF forms in different scenarios.
Use Cases
| # | Scenario | Target Users | Core Pain Point | Solution |
|---|---|---|---|---|
| 1 | First-time PIVOTBY entry | New users | The function name and parameter entry point are unclear | Search for and insert the function from the Insert Function dialog box |
| 2 | Quick editing of an existing formula | Users who work with spreadsheets often | Fewer clicks are preferred | Type =PIVOTBY(...) directly in a cell or in the formula bar |
| 3 | Checking formula syntax | Users who need to verify syntax | The parameter order or help entry is uncertain | Open the parameter details and review the help link |
| 4 | Verifying a formula before filling across cells | Data-processing users | A single incorrect formula may be copied to many cells | Enter the formula in one cell first and confirm the result |
| 5 | Troubleshooting formula errors | Advanced users | It is hard to locate the cause when the result is unexpected | Check syntax, parameters, and formula evaluation together |
Membership & Benefits
Free vs WPS Premium
| Feature | Free User | WPS Member |
|---|---|---|
| PIVOTBY function entry and basic use | ✅ | ✅ |
| Basic PDF features | ✅ Basic access | ✅ More complete features |
| Cloud storage | 1 GB | 20 GB |
| Template downloads | Limited | More available |
Source: WPS Office pricing page
Recommendations
| Use Case | Recommended Plan | Reason |
|---|---|---|
| Daily PIVOTBY entry and testing | Free | It already supports formula entry, editing, and basic spreadsheet work |
| More cloud storage, templates, or broader office features | WPS Member | Suitable for users who also need more suite features and added benefits |
How to Subscribe
- WPS membership center: Subscribe now
Source: WPS Office pricing page