Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to sort numeric values in PivotTable in two ways. Let’s get started
In the caption below, we have data to work with
First Method
We want to sort the Sum of Total in Descending Oder in the first PivotTable Report
- Click on the Account Manager Filter button
- Select More Sort Options
- In the Sort (Account Manager) dialogue box, check Descending (Z to A) by
- In the drop-down, select Sum of Total
- Click OK
Second Method
The other method is much faster with fewer clicks
- Right-click on any numeric values cells
- Select Sort and More Sort Options
- In the Sort By Values dialogue box, check Largest to Smallest
- Click OK
We have the values sorted using the two methods