You can try a couple of things:
Option#1:
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.

Option#2:
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

Hope it helps,
Ryan---

--
RyGuy


"Scott R" wrote:

Hi there was wondering if anyone can help me..
I have a pivot table with columns;
A B C D E
Site Client 2007 total 2008 total Grand Total

I am trying to sort the entire pivot table by column C descending for each
Site. If i use sort it only sorts the first site. If i manually go into each
site and select the range then sort column c desc it unsorts the previous
Site range. I could paste into new sheet and manuallysort each site but there
are a lot of sites and would be great if i could automate this.. any
suggestions would be appreciated...