I knew that I could sort virtually anywhere with Excel Pivot Tables, but I was surprised that I could even sort any row from left to right!!

Below I have an Excel Pivot Table that consists of Sales Numbers over a three year period.

Make sure to download the Excel Workbook below so that we will have the same starting point, we want to sort the table by the values in the April row from Smallest to Largest:

In the example below I show you how to Sort an Item Row from Left to Right:


STEP 1: Right click on a Sales Number in the April row.  Go to  Sort > More Sort Options


STEP 2: Make sure the following are selected: Smallest to Largest, Left to Right.

You can see in the summary that it will sort in ascending order using the values in the April row.

Click OK.


STEP 3: This will sort our sales numbers from left to right using the values in the April row.

See that our years are now arranged in this order: 2014, 2012, 2013.


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest


Share on Facebook


Tweet about this on Twitter


Share on LinkedIn


Share on Google+


Related Posts

Sorting a Pivot Table There are a few ways that you can Sort a Pivot Table.  You can Sort the Row/Column Labels as well as Values within a Pivot Table.  Below I show you three quick ways... DOWNLOAD WORKBOOK Helpful Resource:  
Show The Percent of Difference From Previous Years...   I am sure that your boss has asked you to come up with a Year on Year variance report at some stage.  There are a couple of ways to get him/her an answer. One is using Formulas, but that will take time to set up and you are exposed to errors! The other method is t...
Pivot Table Styles The default Pivot Table style in Excel is very bland and boring, stemming from a lack of creativity from the nerds over at Microsoft! You can give some life to your Excel Pivot Table by simply changing the Pivot Table Style! For our example, this is our Pivot Table: ...
Show The Percent of Column Total With Excel Pivot ... Excel Pivot Tables have a lot of useful calculations under the SHOW VALUES AS option and one that can help you a lot is the PERCENT OF COLUMN TOTAL calculation. This option will immediately calculate the percentages for you from a table filled with numbers such as sales data, ...