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

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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.
 
Upvote 0

Forum statistics

Threads
1,218,746
Messages
6,144,262
Members
450,533
Latest member
xoxo1998

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
Back
Top