Chapter-2: Data Sorting in Pivot Table

We can easily Sort data in pivot table. for example if we have to sort data by Revenue in descending order, below are the steps:

  • Right click on any cell of Sum of Revenue column
  • Go to Sort and click on Sort Largest to Smallest
Sort Data in Pivot Table
Sort Data in Pivot Table

After Sorting the Revenue in descending order pivot will look like below image-

Sorted by Revenue
Sorted by Revenue

Next ChapterPrevious Chapter