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."
根据Mac CPub对excel2011 (OS X)的解释，您可以按照以下方式对“Grand Total”列进行排序:“……”Mac上的Excel没有“按Grand Total排序”选项，但是您可以选择Grand Total列，然后使用ribbon上的Sort按钮来完成这个操作。
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?
你知道怎么让排序按总称排序吗?
3 个解决方案
#1
18
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.
您应该只选择pivot表的数据部分，而不是页眉或页脚(在您的screencast中，从E5开始到A?)。然后可以使用标准排序选项。
#2
1
You can change the sort option of a row label. Click on a row label an choose More sort options . In this menu choose either ascending or descending and choose Count of XXXX from the drop down list.
您可以更改行标签的排序选项。点击一行标签，选择更多的排序选项。在此菜单中选择升序或降序，并从下拉列表中选择Count of XXXX。
#3
1
Here is the fix: I had the same problem and found I had to remove the third of three fields from the "Row" box of the pivot field selector boxes on the far right of the sheet. Then I could sort by Grand Total (just by right clicking in that column). Then when I added the third field back into the Row box it sorted correctly within each level. FYI, to see the field list boxes you must click on the pivot table.
解决方法是:我遇到了同样的问题，发现我必须从表最右边的pivot字段选择器框的“Row”框中删除三个字段中的第三个。然后，我可以按Grand Total排序(只需右键单击该列)。然后，当我将第三个字段添加回行框时，它在每一层中都被正确地排序。要查看字段列表框，必须单击pivot表。
#1
18
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.
您应该只选择pivot表的数据部分，而不是页眉或页脚(在您的screencast中，从E5开始到A?)。然后可以使用标准排序选项。
#2
1
You can change the sort option of a row label. Click on a row label an choose More sort options . In this menu choose either ascending or descending and choose Count of XXXX from the drop down list.
您可以更改行标签的排序选项。点击一行标签，选择更多的排序选项。在此菜单中选择升序或降序，并从下拉列表中选择Count of XXXX。
#3
1
Here is the fix: I had the same problem and found I had to remove the third of three fields from the "Row" box of the pivot field selector boxes on the far right of the sheet. Then I could sort by Grand Total (just by right clicking in that column). Then when I added the third field back into the Row box it sorted correctly within each level. FYI, to see the field list boxes you must click on the pivot table.
解决方法是:我遇到了同样的问题，发现我必须从表最右边的pivot字段选择器框的“Row”框中删除三个字段中的第三个。然后，我可以按Grand Total排序(只需右键单击该列)。然后，当我将第三个字段添加回行框时，它在每一层中都被正确地排序。要查看字段列表框，必须单击pivot表。