How to Create a New Pivot Table in WPS on Android

Use Create New Pivot Table with 4 how-to topics, including 4 free topics and 0 membership-related topics, and jump to each section from the index below.

How-to Index

How-to Guide

1. Open the spreadsheet that contains source data

Entry point: WPS Home or the file list → open a spreadsheet file

1. Open WPS Office.
2. Find the target spreadsheet in Recent, Cloud Docs, or local files.
3. Select the file to enter the spreadsheet editing view.
4. Confirm that the data range includes clear headers and continuous detail records.

Success Criteria

• What you should see: The spreadsheet opens normally.
• What you can do next: You can select the data range and continue to the analysis-related entry.

Tips While Using

• Common mistake: If the source data has no headers, field recognition may be less clear later.
• Environment note: It is better to open and save online files with a stable network connection.

2. Open the create new pivot table entry

Entry point: A data analysis-related option in the spreadsheet editing view

1. Select any cell inside the data area so the current focus stays within the source data.
2. Open the menu related to data processing or analysis.
3. Select the Pivot Table or Create New Pivot Table option.

Success Criteria

• What you should see: The create new pivot table setup screen opens.
• What you can do next: You can continue to choose the data range or confirm where to create the pivot table.

Tips While Using

• Common mistake: If you do not select a cell inside the source data first, the app may not identify the source range as expected.

3. Select the data range and confirm creation

Entry point: The create new pivot table setup screen

1. Check whether the detected data range is complete.
2. Adjust the start and end of the range manually if needed.
3. Confirm that you want to create a new pivot table.

Success Criteria

• What you should see: A new pivot table area or a new worksheet is created.
• What you can do next: You can continue adding row, column, and value fields.

Tips While Using

• Common mistake: Missing part of the source columns can affect the summary result.

4. Start configuring pivot table fields

Entry point: The pivot table editing view after creation

1. In the field list, choose the fields you want to analyze.
2. Add fields to the Rows, Columns, or Values area.
3. Continue adjusting the summary method and layout as needed.

Success Criteria

• What you should see: Grouped summary results appear in the pivot table.
• What you can do next: You can keep changing the field layout or return to the source data to review it.

Tips While Using

• Common mistake: If a text field is placed in the Values area, the result may not match your expectation.