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.
Below I have given an Excel Pivot Table samples that consist of three Regions i.e. Central, East and West.
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
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.