Pivot Table Sum Column Sorting Help

[Dexter11]

I am preparing a pivot table which has rows for job #, description and manager. My sum column is for unbilled amounts and I'm not having the sub-totals displayed. Basically I would like to have the table display my unbilled amounts column sorted from highest to lowest but I am unable to do this since my column is a sum and does not have a filter. See example below for a visual;

job # description manager unbilled amount
122252 bridge repair D. Persn 400,990
652555 freeway rte W. Tuse 1,252,489
045422 constructn A. Nan 6,000

I'm a novice at pivot tables and need help on how to do my sorting based on the amounts from largest to smallest. Please help!!

 

[Hdivision]

Hi Mate

I am a novice also but you can copy and paste the piv into a new sheet and paste special value - then you can add a filter.

 

[MarkCBB]

Hi There Dex,

If you are using xl 2007 or 2010:

depended on which of the 3 rows are the lowest (i.e. the one at the bottim of the set up). select any item in for example Job#, then click on the rows filter, you will see the sorting options there, as well as value filters, i.e. Greater than, equal to lower than etc.

depending on which item in the rows of the PT you are selected will determine on what level the filtering is for examaple if you have Manager abve description and you have description selected on the PT, that is the items that will be filtered.

Hope this helps

 

[Arul.rajesh]

You can use the Autosort function in the pivot.

<a href="http://www.google.com"><img border="0" src="http://img1.imagehousing.com/49/3185c8f146ad4e3b65833527cade5380.gif" alt="Arul">

 

[Dexter11]

Hi Mark,

thank you for your suggestions and the visual guidance. I'm using excel 2010 and I tried what you suggested but it's still not sorting my amounts column. Basically I put my cursor on the first amount, then I right clicked to get the options and selected the sorting from largest to smallest, but nothing happened. Can you provide any guidance on what I'm missing?

Thanks.

 

[Arul.rajesh]

You have three rows, Show the subtotals, right click on the subtotal for the job#, sort largest to smallest>>Hide subtotals...that should work for you.

 

[Arul.rajesh]

<a><img border="0" src="http://img1.imagehousing.com/86/ffbc30601edbdd967894e0fef96b79c5.gif" alt="Image Search"></a>

hope this helps

 

[Dexter11]

Arul.rajesh,

thank you for the additional information. In fact, I have another question, is it possible to also sort the sub-totals from highest to smallest? This is really what I meant to ask initially. I hope you are able to help with this. Thanks

 

[Arul.rajesh]

Arul.rajesh,

thank you for the additional information. In fact, I have another question, is it possible to also sort the sub-totals from highest to smallest? This is really what I meant to ask initially. I hope you are able to help with this. Thanks

Yes it is.