pivot table sort by grand total

[dbrasel]

I'm trying to sort by grand total descending in my pivot table and cannot get it to work.

Column A is a product description
Columns B-L are Months (Periods 1 through 11, populated by a count)
Column M is grand total

Can someone help me?

thanks,

DBrasel[/img]

 

[Serious Sam]

Dbrasel,
A simple way is to click on a cell in the Grand Total column on the Pivot table, then click the Z-A sort button on the standard toolbar.

 

[dbrasel]

thank you! got it to work - sometimes the easiest ways work best!

thanks again, I love this website!

DBrasel