If nobody has a proper solution, you can fall back on:

1. Select the entire pivot table
2. Copy it and paste it Value elsewhere.
3. The copy is a simple table and can be sorted using normal approaches
--
Gary's Student


"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)!