WPS Features
Resources
Free AI Tools
Docs Center

How to Use the PIVOTBY Function in WPS on Windows

Last updated:July 13, 2026

Use the PIVOTBY function with 3 topics: entering it through Insert Function, typing the formula directly, and reviewing syntax and parameter details; choose a topic from the How-to Index and follow the steps.

How-to Index

#TopicMembership
11. Enter it through the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review function syntax and parameter detailsFree

How-to Guide

1. Enter it through the Insert Function dialog box

Entry point: Formulas tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formulas tab.
  3. Search for PIVOTBY in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • UI state: The target cell now contains a PIVOTBY formula.
  • Next actions: You can continue editing parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

  • Common mistakes: A misspelled function name can make the function harder to find.
  • Environment limits: Open a worksheet in WPS Sheets first and make sure the selected cell is editable.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =PIVOTBY(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter details, type =PIVOTBY( and press F1 to view the syntax prompt.

Success Criteria

  • UI state: The cell shows the calculated result or keeps the entered formula.
  • Next actions: You can continue editing the formula, drag to fill, or copy and paste it to another range.

Tips While Using

  • Common mistakes: Incomplete separators or parentheses can prevent the formula from calculating correctly.
  • Environment limits: The shortcut prompt needs to be used while the formula is being edited.

3. Review function syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type PIVOTBY in the search box.
  3. Select the function to review the syntax PIVOTBY(...).
  4. Click the help link for this function to open more details.

Success Criteria

  • UI state: You can see the function name, syntax structure, and parameter details area.
  • Next actions: You can return to the worksheet and continue entering the formula or adjusting parameters.

Tips While Using

  • Common mistakes: If the wrong function is selected first, the displayed details may not match the target function.
  • Environment limits: Opening the help link requires an internet connection.