Pivot Table - Sort by Value

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
I use a pivot table to summarise all sales made by account managers.

Column A - A/c Manager
Column B - Contract Numbers
Column C - Business Line
Column D - Value

I want to look at the consolidated sales by AM, however I would like this to run in descending order in terms of the total value sold by each AM. Problem is I haven't a clue how to get the pivot table to sort the data in that way. I can get it to sort by AM, Line of business, contract but not value.

What am I missing or doing wrong?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

jimboy

Well-known Member
Joined
Apr 11, 2002
Messages
2,314
In the Pivot wizard (in Layout) double click on the item you want to sort by (in the row field) and click advanced, in the autosort options select Ascending/Descending and change the drop down in Using field.
 

garymu16

Board Regular
Joined
Sep 15, 2006
Messages
139
The value section is in data not row and it has to stay in that secion of the pivot table.
 

Forum statistics

Threads
1,136,267
Messages
5,674,729
Members
419,523
Latest member
Urnovio

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top