Create New Pivot Table in WPS on Android FAQ

Last updated:July 23, 2026

When using Create New Pivot Table in WPS on Android, the most common questions focus on data preparation, finding the entry, and understanding the result layout. This FAQ includes 4 common questions.

FAQ

Why can’t I find the create new pivot table entry?

  1. Confirm that you opened a spreadsheet file instead of a document or presentation file.
  2. Make sure you are already in the spreadsheet editing view and have selected a cell inside the data area.
  3. Check the menus related to data analysis or pivot tables again.

What should the source data look like before I create a new pivot table?

  1. The data range should include clear headers.
  2. Detailed records should stay as continuous as possible, without many blank rows or columns in the middle.
  3. Data types in the same column should stay consistent so the summary is easier to build.

Why does the summary result look different from what I expected?

  1. Check whether part of the source range was left out.
  2. Check whether each field was placed in the correct Rows, Columns, or Values area.
  3. If the source data contains text, blanks, or inconsistent formatting, clean the source table first and then review the result again.

Where is the new pivot table saved?

  1. The pivot table is usually saved in the current spreadsheet file.
  2. If it is created as a new worksheet, switch worksheets inside the current file to find it.
  3. After you save the file, the pivot table structure stays with that file.

Glossary

TermDefinition
Pivot tableA spreadsheet tool used to group, summarize, and cross-analyze source data.
Data rangeThe source cell area used to generate the pivot table.
FieldA column header in the source table that becomes a category or summary dimension in the pivot table.
Values areaThe part of a pivot table that shows summarized results such as sums or counts.