How to Use WPS Pivot Table on Android

Use WPS Pivot Table in 4 topics, including opening the Pivot Table entry, selecting the source range, adding fields, and exporting the result; choose a topic from the How-to Index and follow the entry path and steps.

How-to Index

How-to Guide

1. Open the Pivot Table entry

Feature entry: Tools → Insert → Pivot Table

1. Open the spreadsheet file that you want to analyze.
2. Tap Tools at the bottom.
3. Select the Insert tab.
4. Tap Pivot Table.

Success Criteria

• Interface result: The Pivot Table creation flow opens.
• Next action available: You can continue to select the source data range.

Tips While Using

• Common mistake: If no spreadsheet file is open first, you cannot continue to the creation steps.

2. Select the source data range

Feature entry: Pivot Table creation screen

1. Select the data range in the worksheet that you want to use for the Pivot Table.
2. Check whether the selected range includes the columns you want to summarize.
3. Tap Done to continue.

Success Criteria

• Interface result: The selected range is accepted and the field setup screen opens.
• Next action available: You can add row fields and column fields.

Tips While Using

• Common mistake: If the source data has no headers or includes merged cells, the summary result may be harder to review.
• Environment note: It is recommended to organize the source data by columns, with one field per column.

3. Add row fields and column fields

Feature entry: Field setup screen

1. Add column fields based on your analysis goal.
2. Add row fields based on your analysis goal.
3. Adjust the field combination as needed to review different summary dimensions.

Success Criteria

• Interface result: The Pivot Table structure shows the selected row and column dimensions.
• Next action available: You can export and review the summarized result.

Tips While Using

• Common mistake: If fields are placed in unsuitable areas, the result may not match your expectation, so adjust the field placement again.

4. Export and finish creation

Feature entry: After field setup is complete

1. Confirm that the row fields and column fields are set.
2. Tap Export.
3. Review the generated Pivot Table result.

Success Criteria

• Interface result: A viewable Pivot Table result is generated.
• Next action available: You can continue reviewing the summary or return to the original sheet to adjust the data.

Tips While Using

• Common mistake: Editing Pivot Table result cells directly does not change the source data.
• Environment note: More complex configurations are usually easier to complete on a desktop device.