Pivot Table Issues

Sort an Excel PivotTable by a Count or Value Field

John WilsonJohn Wilson Nov 22, 2026 868 views

Question details

Sort PivotTable row items by a value-area field, such as customer count.

How to Sort an Excel PivotTable by a Count or Value Field
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.
Before you start

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.

Solution 1Recommended

Sort PivotTable rows from a value cell

Use a number in the value column to rank the associated row items without a filter arrow.

1
Select a value

In the PivotTable, right-click a number in the Count or other value column you want to sort by.

2
Choose the sort order

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.

3
Check the row order

Review the row labels to confirm that items such as stores are ranked by the selected values.

Sort PivotTable rows from a value cell
Sorting grouped rows: The sort reorders PivotTable items rather than individual source records. If the PivotTable has multiple row levels, items may be sorted within their groups.
Sort PivotTable values in WPS

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. 1. Open the workbook: Launch WPS Spreadsheets and use File > Open to select the Excel workbook containing your PivotTable.
  2. 2. Find the value column: Click the worksheet tab containing the PivotTable and locate the Count or other value column.
  3. 3. Sort by the value: Right-click a number in that column, choose Sort, and select the descending or ascending option.
  4. 4. Save the workbook: Check the row order, then choose File > Save As to save the workbook in your preferred format.
Rank PivotTable items by a count or another valueOpen and save Microsoft Excel XLSX workbooksWork with spreadsheets in a familiar interfaceUse WPS Office for free
microsoft office alternative - wps office

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.