sorting pivot table by sorts by "show value as"

[cardactiveunit]

Hello,

Excel 2007.

In my pivot table I have, in the value area, a quantity that has the
value field settings:
*Summarize value field by: Count
*Show values as: % of row

The only problem is when I try to sort the pivot table by value, it
sorts by Count rather than the displayed % of row. I would rather it
sorted by the displayed % of row value.

Anyone know how to do this?

cheers

Vin

 

[Vin]

Hi,

Just a little more information. I think this must be a bug because the
Summary section at the bottom of the sort dialog box suggests that it will
sort the list by the displayed '% of row' values but instead it sorts by the
underlying Count.

So I think I am looking for a workaround rather than an intended function.

Cheers

Vin