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

Group Sales by Weeks With Excel Pivot Tables I am sure that your boss has asked you to come up with Total Sales numbers per week at least once in your current role!  If not, he will....very very soon! Now your data has only sales for each individual day, which makes you scramble to come up with a solution.   How will you...
Count VS Sum in Pivot Tables The #1 complaint that I get from Pivot Tables is "Why do my values show as a Count of rather than a Sumof ?" Well there are three reasons why this is the case: 1. There are blank cells in your values column within your data set; or 2. There are "text" cells in your value...
Show The Percent Of With Excel Pivot Tables   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 calculation. It will display the value of one item (the Base Field) as the percentage of another item (the Base Item). This optio...
Group By Custom Dates With Excel Pivot Tables In my previous Group By Month post, we grouped our Sales by each month. However the cool thing with Excel is that we can take that a step further and customize our grouped date range! In the example below I show you how to get the Sales Grouped by Custom Dates:   ...