How to Create a New Pivot Table in WPS on macOS

Use Create New Pivot Table through 4 how-to topics, with 4 available without membership and 0 membership-related items; choose a topic from the index to complete the task quickly.

How-to Index

How-to Guide

1. Open the PivotTable creation entry

Entry point: Open your spreadsheet file, then use the Insert area or another PivotTable-related entry.

1. Open WPS Spreadsheet on your Mac and load the file you want to analyze.
2. Click any cell inside the data range so the current worksheet is active and editable.
3. Find the PivotTable-related creation entry in the top menu bar.
4. Click the command to create a new PivotTable.

Success Criteria

• Interface result: The PivotTable creation window or setup panel opens.
• What you can do next: You can continue selecting the source range and destination.

Tips While Using

• Common mistake: If you do not first place the cursor inside the data range, the detected range may not be accurate.
• Environment note: The current file needs to be an editable spreadsheet file.

2. Select the data range to summarize

Entry point: Set the source range in the creation window.

1. Review the data range detected automatically.
2. If the detected range is not what you need, manually select the cell range to summarize.
3. Make sure the range includes complete headers and the data you want to analyze.

Success Criteria

• Interface result: The correct source range is shown in the creation window.
• What you can do next: You can continue to confirm where the PivotTable will be placed.

Tips While Using

• Common mistake: Blank rows, blank columns, or missing headers can make the summary harder to analyze.

3. Confirm the location and create the PivotTable

Entry point: Confirm the destination in the creation window.

1. Choose to place the PivotTable in a new worksheet or in a specified location.
2. Check whether the current setting matches your analysis needs.
3. Click Confirm or OK to generate the new PivotTable.

Success Criteria

• Interface result: A new worksheet is created or a PivotTable layout is inserted in the selected location.
• What you can do next: You can continue adding fields and reviewing summary results.

Tips While Using

• Common mistake: Choosing an unsuitable destination may affect the layout of the current worksheet.

4. Add fields to start summary analysis

Entry point: Continue in the PivotTable field area after creation.

1. Select the fields you want to analyze from the field list.
2. Add fields to the Rows, Columns, or Values area.
3. Adjust field order as needed and review how the summary changes.
4. Continue refining the layout to complete a basic analysis view.

Success Criteria

• Interface result: The PivotTable displays categorized summary results.
• What you can do next: You can continue filtering, adjusting fields, or refreshing results.

Tips While Using

• Common mistake: If you place a text field directly in the Values area, the result may show a count instead of a sum.