It is known that how to sort virtually from largest to smallest with Excel Pivot Tables but do you know that it can be done by anywhere with Grand Totals.

Previously In Excel Pivot TablesHow to Sort Largest to Smallest Grand Totals with Excel Pivot Tables?

Below I have given an Excel Pivot Table samples that consist of three Regions i.e. Central, East and West.

Sort Largest to Smallest

In this tutorial I have given all the steps to Sort by Largest to Smallest based on Grand Totals:

Sorting Totals From Largest To Smallest

Firstly, you need to right-click on a Grand Total below at the bottom of the Pivot Table and,

then Go to Sort > Sort Largest to Smallest

Sort Largest to Smallest

after that, your grand totals will be sort by descending order.

For example see that my regions are now arranged in the given order: Central, West and East.

How to Sort Largest to Smallest Grand Totals with Excel Pivot Tables? 1