Thank you Debra. That is actually the method from the help file and I really
can't understand why I couldn't make it work before. However, it works now!
It might be because I'm doing this on consolidation now rather than from the
same data area. In any event, thank you very very much!

"Debra Dalgleish" wrote:

Double-click the first Row field button
Click the Advanced button
For AutoSort, choose Descending
From the Using Field dropdown, select the data field,
e.g. "Sum of Units"
Click OK, click OK.

Aaron Howe wrote:
Is there a way to sort the grand total *row* of a three-column PivotTable in
Excel? I have a month-by-month analysis to do on client spending, and have
consolidated the three months into a PivotTable using the wizard. Now I need
to sort this list by total spend but when I try to sort I get the error:

"Cannot determine which PivotTable field to sort by". I have tried using
the Advanced options for sorting but these are no good as they don't work on
the Grand Total column itself. Has anyone managed to make a PivotTable sort
without using VB? I'm sure there must be a simple answer (it's one of those
Excel functions that you expect it to do without any effort)!


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html