Regarding Pivot table sorting problem

Hi,


Pls. find attached the pivot table. I want to sort the Pivot table by "NAME" then by "SUM OF COUNT" - DESCENDING then by "SUM OF PERSON" - ASCENDING. How to achieve this in Excel 2007 & excel 2003. Please Help. Thanks in advance.

Pls. help. Nobody is responded to my query. Pls. help

Select D5
Sort A-Z
Select C5
Sort Z-A
Click B5
Sort A-Z

Data sorted as per request

HTH

Thank you very much charlie...