Hi

I have a Pivot table on a separate worksheet that gathers information
from several other worksheets, the data being number of 1st place
finishes, 2nd place finishes and 3rd place finishes.

So, the table is thus:

Rows are Name, Nat (Nationality)

Column is 'Values'

Values are 1st Place, 2nd Place, 3rd Place.

I have been able to sort this, so that the people are ranked 'Largest
to smallest', but it will only do this for the '1st Place' column
values.

I would like to further sort this so that 2nd places and 3rd places
are further sorted (again, largest to smallest), much in the same way
I would do this in a none pivot chart.
IE if 2 people tied on 1st places, the 2nd places and/or 3rd's would
further rank them.

Is this not possible, or did I miss something somewhere!
I am using Excel 2007

Thanks
Neil