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.

Post by 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.

Post by 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
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

[t***@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.

Post by 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

[a***@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...

Post by t***@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.

Post by 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

[j***@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.

Post by t***@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.

Post by 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

[r***@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.

[c***@gmail.com]

Post by j***@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.

Post by t***@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.

Post by 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

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

[[e-mail]]

Post by 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.

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.

[s***@gmail.com]

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

[w***@gmail.com]

Post by ***@gmail.com

Post by 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.

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.

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

[m***@gmail.com]

THANK YOU! I HATE MICROSOFT!

Cheers,
-mark

Post by w***@gmail.com

Post by ***@gmail.com

Post by 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.

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.

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

[j***@gmail.com]

OMG thank you that was seriously infuriating.

Post by ***@gmail.com

Post by 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.

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.

[z***@lollywollydoodle.com]

Post by ***@gmail.com

Post by 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.

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.

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

[s***@gmail.com]

Post by z***@lollywollydoodle.com

Post by ***@gmail.com

Post by 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.

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.

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

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!

[m***@gmail.com]

Post by s***@gmail.com

Post by z***@lollywollydoodle.com

Post by ***@gmail.com

Post by 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.

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.

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

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!

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

[r***@iruleathome.com]

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