How to Sort a PivotTable by Individual Sales Instead of Customer Totals in WPS Office Spreadsheets
Question details
The user needs to sort an Excel PivotTable by individual sales amounts rather than by each customer's combined total because the current sort only orders customer groups.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- The PivotTable groups multiple sales lines under each customer, and the user needs to reorder the individual sale rows instead of the customer totals.
- Observed behavior
- When using Sort by Value, the PivotTable sorts the aggregated customer groups rather than the individual sales entries.
Open the workbook in WPS Office Spreadsheets and click any cell inside the PivotTable. Open the PivotTable Fields pane so you can see the current Rows, Columns, and Values layout before changing the sort.
Sort Individual Sales Values After Placing the Sales Field in the Rows Area
Use this method when the PivotTable currently sorts customer totals but you need each individual sales amount to be ordered.
A PivotTable sorts items at the current row-field level. When the individual sales field is visible in the Rows area, you can right-click a sales amount and sort it directly.
Click any cell in the PivotTable, go to the PivotTable Analyze tab, and click Field List.
In the PivotTable Fields pane, drag the field that contains individual sales amounts, such as Sales Amount or Order Total, into the Rows area below the Customer field.
Right-click any individual sales amount in the PivotTable, choose Sort, and select Sort Largest to Smallest or Sort Smallest to Largest.
If customer groups still control the sort, move the individual sales field above Customer in the Rows area or remove the Customer field from Rows.
Rearrange or Remove Higher-Level Row Fields When Sales Are Still Grouped
Use this method when the PivotTable keeps grouping individual sales under a parent field and the Ungroup command is disabled.
Sort a PivotTable by Individual Sales Values in WPS Office Spreadsheets
Open your Excel workbook in WPS Office Spreadsheets, use the PivotTable Fields pane to place the individual sales field in the Rows area, then right-click a sales amount and choose Sort to order individual values instead of customer totals.
- 1. Open the PivotTable in WPS Office Spreadsheets: Launch WPS Office Spreadsheets, open the Excel workbook, and click any cell in the PivotTable.
- 2. Show the PivotTable Fields pane: Go to the PivotTable Analyze tab and click Field List to open the field pane.
- 3. Move the individual sales field into Rows: Drag the individual sales field under or above Customer in the Rows area so sales amounts appear as separate row items.
- 4. Right-click a sales amount and sort: Right-click any sales amount, select Sort, and choose Sort Largest to Smallest or Sort Smallest to Largest.
- 5. Verify the order: Check that individual sales values are sorted as intended; adjust the Rows area order if customer grouping still takes priority.
Frequently Asked Questions
Why does Sort by Value sort customer totals instead of individual sales in my PivotTable?
PivotTable sorting works at the current row-field level. If Customer is the top row field, WPS Office Spreadsheets sorts the aggregate customer totals. Place the individual sales field in the Rows area and right-click a sales amount to sort it directly.
How do I make individual sales amounts appear as separate rows in a PivotTable?
Open the PivotTable Analyze tab, click Field List, and drag the individual sales field into the Rows area below Customer. You can also remove other row fields that are creating the unwanted grouping.
The Ungroup option is disabled. How can I separate customer groups?
This usually means the grouping comes from the row-field hierarchy rather than manual grouping. In the PivotTable Fields pane, rearrange or remove higher-level row fields such as Customer.
Can I sort individual sales inside each customer group in WPS Office?
Yes. Place the sales field below Customer in the Rows area, then right-click a sales value and choose Sort. The values will be sorted within the current row-field level.
Will sorting by individual sales affect Excel compatibility?
No. WPS Office Spreadsheets preserves the PivotTable structure and .xlsx compatibility when you save the workbook.
