WPS Pivot Table on macOS FAQ

Common Pivot Table questions on macOS usually involve creation, refresh behavior, summary methods, and source changes; this FAQ includes 4 common questions and a glossary.

FAQ

Why does the Pivot Table not show the result I expected after creation?

1. Check whether the correct data range was selected.
2. Make sure fields have been placed in Rows, Columns, Values, or Filters.
3. Confirm that the source data includes clear headers and avoids empty key fields.
4. Adjust the field layout again and review the updated result.

Why do the results change a lot after I switch the summary method?

1. Open Value Field Settings.
2. Check whether the current method is Sum, Count, Average, Max, or Min.
3. Compare the selected method with the field's data type.
4. Try another summary method if you need a different statistical view.

Why does the slicer not filter the Pivot Table after I insert it?

1. Make sure the target Pivot Table was selected before the slicer was inserted.
2. Check whether the slicer is linked to a field from the current Pivot Table.
3. Click different slicer options and see whether the Pivot Table updates.
4. If needed, insert the slicer again and reselect the field.

Why does the original layout stop looking right after I change the data source?

1. Check whether the new source range still keeps the original field structure.
2. Open the field pane and confirm that the fields in Rows, Columns, Values, and Filters still match.
3. If field names or structure changed, drag the fields again to rebuild the layout.
4. Review the updated summary result after the adjustment.

Glossary