Pivot table sorting - can I do this?
 

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

Pivot table sorting - can I do this?
 

Assuming that I understand the question the short answer is no. A field (such
as name) can only be sorted on a single other Field (such as 1st Place). Your
only alternative is to create some sort of a single field that gives you
ordinal placemant. Similar to standings in sports. 1st place is worth 10
points, second is worht 5 and third is worth 1...
--
HTH...

Jim Thomlinson


"neil40" wrote:

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

Pivot table sorting - can I do this?
 

On 9 Sep, 17:18, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
Assuming that I understand the question the short answer is no. A field (such
as name) can only be sorted on a single other Field (such as 1st Place). Your
only alternative is to create some sort of a single field that gives you
ordinal placemant. Similar to standings in sports. 1st place is worth 10
points, second is worht 5 and third is worth 1...
--
HTH...

Jim Thomlinson

"neil40" wrote:
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

Jim,

Yes you did understand correctly.
That's a shame. You'd think there were more options to sort this kind
of data.
Ah well, unless anyone else does know of a way