Sort Numeric Values in PivotTable in Two Ways

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

Posted in Blog and tagged , , .

Leave a Reply

Your email address will not be published. Required fields are marked *