Sort an Excel PivotTable by a Count or Value Field
Question details
Sort PivotTable row items by a value-area field, such as customer count.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A user wants to rank stores or other row items by a PivotTable count or value field.
- Observed behavior
- The value column has no standard filter arrow, but its numbers can be used to sort the associated row items.
Check that the field you want to sort by is in the PivotTable Values area and displays a number for each row item. If the PivotTable has multiple value columns, identify the column you want to use for the sort.
Sort PivotTable rows from a value cell
Use a number in the value column to rank the associated row items without a filter arrow.
In the PivotTable, right-click a number in the Count or other value column you want to sort by.
Select Sort, then choose Sort Largest to Smallest or Sort Smallest to Largest. Depending on the Excel version, the descending option may appear as Sort Z to A.
Review the row labels to confirm that items such as stores are ranked by the selected values.

Rank PivotTable items by count in WPS Spreadsheets
Open your workbook in WPS Spreadsheets and sort PivotTable row items using the count or value column you want to compare.
- 1. Open the workbook: Launch WPS Spreadsheets and use File > Open to select the Excel workbook containing your PivotTable.
- 2. Find the value column: Click the worksheet tab containing the PivotTable and locate the Count or other value column.
- 3. Sort by the value: Right-click a number in that column, choose Sort, and select the descending or ascending option.
- 4. Save the workbook: Check the row order, then choose File > Save As to save the workbook in your preferred format.

Frequently Asked Questions
Can I sort a PivotTable value column without a filter arrow?
Yes. Right-click a number in the value column, select Sort, and choose the desired order.
How do I put the highest customer counts first?
Right-click a customer count in the PivotTable and choose Sort > Sort Largest to Smallest. Some Excel versions may label the descending option Sort Z to A.
Does sorting by a count rearrange the source data?
No. Sorting from a PivotTable value cell changes the order of PivotTable items, not the order of records in the source data.
Why are my PivotTable items sorted only within groups?
When multiple fields are in the Rows area, Excel can sort items within each parent group. Check the row field layout in the PivotTable Fields pane if you need a different ranking.




