Pivot Table Sorting 1

[MeGustaXL]

Hi,

I have a PT that looks like this:
Hardware
Involved Closed Total
Design Reply awaiting approval 100
Reply awaited 10
Closed 18
Interim reply 6
Reply Received 1
Build Reply awaiting approval 59
Reply awaited 25
Closed 11
Interim reply 4
Reply Received 2


How can I get it to sort both groups Descending?
As you can see, the Build ones are already sorted this way, but I want the Design ones sorted as well.

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson

 

[xlbo]

right click on field header
Field Settings
Advanced
Sort descending

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[MeGustaXL]

Super Speed Geoff!

I'd forgotten that I can specify which data to base the sort on!

Have a STAR!

Chris

So you ride yourselves over the fields,
and you make all your animal deals,
and your wise men don't know how it feels...

Ian Anderson