Create New Pivot Table in WPS on Windows FAQ

This FAQ covers 4 common questions about creating a new PivotTable in WPS on Windows, including data preparation, missing fields, placement choices, and result adjustments.

FAQ

Why can’t I see the field I want?

1. Check whether the original data includes complete headers.
2. Make sure you selected the correct data range before creating the PivotTable.
3. If a field name is blank or unclear in the source table, clean up the original data first.
4. Recreate the PivotTable and review the field list again.

Should I place the PivotTable in a new worksheet or an existing worksheet?

1. Choose New Worksheet if you want the summary separate from the source data.
2. Choose Existing Worksheet if you want the result near the current sheet content.
3. Before using an existing worksheet, make sure the target area has enough empty space.

What should I do if the result does not look right after dragging fields?

1. Check whether numeric fields are placed in the Data area.
2. Check whether category fields are placed in the Row or Column area.
3. Swap field positions to compare different layouts.
4. Remove and drag the fields again if needed.

Does deleting a PivotTable affect the original data?

1. Deleting removes the generated PivotTable view.
2. The original source data remains in the worksheet.
3. If you need another summary, you can create a new PivotTable from the same source data again.

Glossary