Advanced Pivot Table sorting

[Kdizzle]

This seems to be missing in Excel 2011. In 2008, I could pick a
field, right-click, field settings, advanced, auto-sort options and
sort by "using field". Where did this go in 2011? This has been
sooooo frustrating. Thanks in advance.

[Mark Quinn]

Hi Kdizzle,

This frustrated me too!

There are two ways to sort pivot table data in 2011... the easiest way is to click within the column of data you want to sort by, and then click the "sort" icon up on the static toolbar (the icon is probably in about the center of the toolbar and looks like an "A" on top of a "Z" with an arrow pointing down to the right of the letters).

The other way is to click within the column you want to sort and then select Data, Sort... from the menu bar.

Best,
Mark

Submitted via EggHeadCafe
Microsoft Silverlight For Beginners
http://www.eggheadcafe.com/training-topic-area/Microsoft-Silverlight/10/Silverlight.aspx

[Tom Schmidt]

Hi Mark, but how do I sort the pivottable by the Total column? I am banging my head against the wall here.

>> On Saturday, December 18, 2010 6:32 PM Mark Quinn wrote:

>> Hi Kdizzle,
>>
>>
>>
>> This frustrated me too!
>>
>>
>>
>> There are two ways to sort pivot table data in 2011... the easiest way is to click within the column of data you want to sort by, and then click the "sort" icon up on the static toolbar (the icon is probably in about the center of the toolbar and looks like an "A" on top of a "Z" with an arrow pointing down to the right of the letters).
>>
>>
>>
>> The other way is to click within the column you want to sort and then select Data, Sort... from the menu bar.
>>
>>
>>
>> Best,
>>
>> Mark

>> Submitted via EggHeadCafe
>> SharePoint Status Bar Access Via Client Side API
>> http://www.eggheadcafe.com/tutorials/aspnet/4bc37d0d-4e04-4202-9828-c6b717744989/sharepoint-status-bar-access-via-client-side-api.aspx

[Gib]

The previously posted solution works in any column.

Submitted via EggHeadCafe
Stock Quotes via jQuery-enabled WCF Service, JSON, and jQuery Templates
http://www.eggheadcafe.com/tutorials/aspnet/9c157185-9ded-4352-8311-73153d9d1297/stock-quotes-via-jqueryenabled-wcf-service-json-and-jquery-templates.aspx

[tri...@gmail.com]

No it doesn't. It won't sort the values in a pivotable. I can't figure out how to do it either. You can only sort the values that you've put in the row labels, you can't sort the values.

[analytics....@gmail.com]

It's true, i can't use sort features on values, only avialable on Rows (left column). Well I'll just copy my pivot into a table and sort it there...

[jmwh...@gmail.com]

It took me a while to figure it out as well. The sort icon that Mark Quinn refers to is in the "Data" ribbon menu. You might not be able to see it because you might be looking at the "Pivot Table" sub-ribbon menu.

[rich...@gmail.com]

I can find the Sort icon, but it simply doesn't work when you need to sort the table by the values. It will sort within the first grouping, but not the entire table. It worked in previous versions of Excel.

[opera...@surfblanksamerica.com]

Select the 1st value in the column within the table that you would like sort by, the sort icon or the Data:Sort menu tree will allow you to sort the entire table based on the values within the column you selected.

[spav...@gmail.com]

Every time I attempt to do this, Excel crashes completely. WTF?

[wiley...@gmail.com]

Thank you for this - this finally worked for me. So wack and frustrating that none of the other options I was trying were working.

[mark...@gmail.com]

THANK YOU! I HATE MICROSOFT!

Cheers,
-mark

[ro...@iruleathome.com]

PJ, Thank you so much. Your solution works. This was really frustrating. Very poor software design.

[jse...@gmail.com]

OMG thank you that was seriously infuriating.

[za...@lollywollydoodle.com]

After 10 google searches, I finally have an answer. It works by selecting just the 1st value... but no other way. Blah.

[spit...@gmail.com]

bah! Not working for me. Have been working on this for days!. MAC/Yosemite; Excel 2011.

If I have only two columns of data, it works. No filters, no nothing. Quite unusable in this state. If I have more than two columns of data or if I filter the data, sorting does not work... Microsoft... are you listening? Please fix!

[macal...@gmail.com]

Did anyone ever figure this out? I have the exact same problem you've described.

[charle...@gmail.com]

This is the info that finally helped me figure out the issue. Thank you sooooooooooo much.