When using Pivot Table, common questions usually focus on the feature entry, source data selection, and result adjustment; this page includes 3 common questions and a glossary.
FAQ
Why can’t I find the Pivot Table entry?
- Make sure you opened a spreadsheet file instead of a Writer or Presentation file.
- Tap Tools at the bottom, then open the Insert tab and check whether Pivot Table is available.
- If the entry still does not appear, update WPS Office to the latest version and try again.
What should the source data look like before I create a pivot table?
- Make sure the data is organized by columns and that each column has a clear header.
- Try not to use merged cells in the source data range.
- Check for blank headers or obvious data errors to avoid affecting the summary result.
Why can’t I directly edit the values in a pivot table result?
- A pivot table shows summarized results based on the source data.
- Editing cells in the pivot table does not change the original data.
- To change the result, update the source data or adjust the fields and generate the result again.
Glossary
| Term | Definition |
|---|---|
| Pivot Table | A tool used to group, summarize, and analyze detailed data. |
| Source Data Range | The original cell range used to generate the pivot table. |
| Row Field | A field that controls how data is displayed by row labels in the pivot table. |
| Column Field | A field that controls how data is displayed by column labels in the pivot table. |