Create New Pivot Table in WPS on macOS FAQ

When using Create New Pivot Table, the most common questions focus on finding the entry, selecting the correct data range, understanding the result, and adjusting the PivotTable afterward.

FAQ

Why can’t I find the Create New Pivot Table entry?

1. Make sure you opened a WPS spreadsheet file instead of a Writer or Presentation file.
2. Check that the current worksheet is editable and that a cell inside the data range is selected.
3. Look for the PivotTable entry in the top menu bar or Insert-related area.
4. If it still does not appear, update to a newer WPS Office for Mac version and try again.

Why is the data range incorrect when I create a PivotTable?

1. Check whether the source data is organized by columns and whether the first row contains headers.
2. Remove unrelated blank rows, blank columns, or scattered ranges.
3. Manually reselect the range you want to summarize in the creation window.
4. Confirm the range again before continuing.

Why don’t I see the summary result I expected after creating the PivotTable?

1. Make sure you have added fields to the Rows, Columns, or Values area.
2. Check whether the field type in the Values area matches the summary method you want, such as sum or count.
3. Adjust field positions and review whether the result changes.
4. If the source data has changed, refresh the PivotTable and check again.

Can I still adjust the PivotTable after it is created?

1. Yes. You can continue adding, removing, or dragging fields in the field list.
2. You can rearrange fields in the Rows, Columns, and Values areas.
3. If you need a different analysis range, recreate the PivotTable or adjust the source settings.
4. After the adjustment, review the updated summary result.

Glossary