How to sort ascending in pivot table?

Let’s sort a very basic pivot table. Here we have wanted to sort the Grand Total from smallest to largest to know the most selling product.

Similarly, you can sort the data from smallest to largest value by following the same steps.

Here in the above Pivot table, both the Grand Total columns and rows are sorted from Largest to Smallest value.

Imagine, now you need to sort Product Cake from “Smallest to Largest” or vice versa. You can do this using a custom sort option.

Now, what if you need to make a minor change other than the selected pattern in your pivot.

For example, you have sales data from Jan till Dec. Let’s assume you need to bring the current month let’s say August to the top?? This does not fit into any set pattern.

Don’t worry, this is possible. In such cases, you can sort the pivot table manually. Here’s a simple example.

Now in the above table, we have the data organized from Jan till Dec in the Columns and the Countries sorted in alphabetical order. Follow the below steps to bring “Aug” in the first column and “India” in the top row.

Now let us sort the countries into alphabetical order for the convenience of our audience. This can be done in two different ways.

In a PivotTable, click the small arrow next to Row Labels and Column Labels cells. Click a field in the row or column you want to sort. on Row Labels or Column Labels, and then click the sort option you want. To sort data in ascending or descending order, click Sort A to Z or Sort Z to A.

• Right-click on a value cell, and click Sort.
• Then, click Sort Smallest to Largest or Sort Largest to Smallest.