Sort by "Grand Total" Column in Excel PivotTables?

excel pivot-table excel-2011
ylluminate picture ylluminate · Oct 4, 2012 · Viewed 74.8k times · Source

As per an explanation found here by Mac CPub fro Excel 2011 (for OS X) supposedly you can sort "Grand Total" columns as per the following: "... Excel for Mac doesn't have a "Sort by Grand Total" option, but you can select the grand total column and then use the Sort button on the ribbon to do this."

When I attempt perform this function it unfortunately seems to be disabled as you can see in this short screencast.

Any idea as to how to allow sorting by Grand Total?

Answer

Romain picture Romain · Oct 4, 2012

You should select only the data part of your pivot table, not the headers or footers (in your screencast, starting form E5 down to A?). You can then use the standard sort option.

Related questions

Simple Pivot Table to Count Unique Values

This seems like a simple Pivot Table to learn with. I would like to do a count of unique values for a particular value I'm grouping on. For instance, I have this: ABC 123 ABC 123 ABC 123 DEF 456 DEF 567 DEF 456 DEF 456 What …

Read More
PivotTable to show values, not sum of values

I'm wanting to display a pivot table and for it to show me the actual values, one on each row, rather than a sum of the values. E.g. Name Jan Feb Mar Apr Bob 12 10 4 3 5 James 2 6 8 1 15 etc. My starting point …

Read More
Filter Excel pivot table using VBA

I have tried copying and pasting solutions from the internet forever now to try to filter a pivot table in Excel using VBA. The code below doesn't work. Sub FilterPivotTable() Application.ScreenUpdating = False ActiveSheet.PivotTables("PivotTable2").ManualUpdate = True ActiveSheet.PivotTables("…

Read More