How to Use the PIVOTBY Function in WPS on Windows

This guide includes 4 how-to topics for PIVOTBY, with 4 free topics and 0 membership-related topics; choose a topic from the index and follow the steps.

How-to Index

How-to Guide

1. Enter the PIVOTBY function

Entry point: Formulas tab → formula bar

1. Open AirSheet and select the cell where you want to enter the formula.
2. Type = in the formula bar or directly in the cell.
3. Continue by typing PIVOTBY(.
4. Confirm that the function is now in editing state.

Success Criteria

• UI state: =PIVOTBY( appears in the cell or formula bar.
• Next actions: You can continue entering parameters and complete the formula.

Tips While Using

• Common mistakes: If you do not type = first, the content may be treated as plain text.

2. Check syntax prompts and parameter requirements

Entry point: formula editing state after typing =PIVOTBY(

1. Type =PIVOTBY( in a cell.
2. Wait for the syntax prompt to appear automatically.
3. Review the parameter requirements and example content.
4. Prepare the remaining inputs based on the prompt.

Success Criteria

• UI state: A syntax prompt appears and shows parameter requirements and examples.
• Next actions: You can continue filling in parameters based on the prompt.

Tips While Using

• Common mistakes: If the function name is incomplete or misspelled, the syntax prompt may not appear as expected.

3. Use cross-sheet references

Entry point: Formulas tab → formula bar

1. Select the target cell and type =PIVOTBY(.
2. Move to the worksheet that contains the data you want to reference.
3. Select the cell or range to include in the formula.
4. Return to the current worksheet and complete the remaining parameters.
5. Press Enter to confirm the formula.

Success Criteria

• UI state: The formula includes a reference to another worksheet.
• Next actions: After confirmation, the current cell shows a calculation result.

Tips While Using

• Common mistakes: An incomplete reference range can affect the result.
• Environment limits: The referenced worksheet data must be accessible.

4. Create nested calculations and confirm automatic recalculation

Entry point: Formulas tab → formula bar

1. Enter a formula that includes PIVOTBY in the target cell.
2. Add other functions in the parameters when needed to build a nested calculation.
3. Press Enter and review the initial result.
4. Change the source data in the referenced cells.
5. Check whether the result updates automatically.

Success Criteria

• UI state: The cell shows a calculation result, and the result changes after the source data changes.
• Next actions: You can continue editing the formula or adjust the reference range.

Tips While Using

• Common mistakes: Unmatched parentheses or incorrect separators can cause formula errors.
• Environment limits: If the result does not change right away, check whether the calculation has finished.