V
Vin
Hello,
This is a problem with sorting a pivot table in Excel 2007.
For my values I have selected the value field settings:
*Summarize value field by: Count
*Show values as: % of row
So the displayed values are '% of row' based on the underlying 'Count'
values which are not displayed.
When I try to sort the pivot table by these displayed '% of row' values it
sorts by un-displayed 'Count' instead. This is despite the fact that the
Summary section at the bottom of the sort dialog box suggests that it will
sort the list by the displayed '% of row' values.
Seems to me to be a bug. Does anyone know a workaround if so, or what I am
doing wrong if it is not a bug?
many thanks
Vin
PS - I already posted this in Excel section, but it doesn't seem to show up
when one browses to the excel message board top level. So thats why I
re-posted here in the excel-general section.
This is a problem with sorting a pivot table in Excel 2007.
For my values I have selected the value field settings:
*Summarize value field by: Count
*Show values as: % of row
So the displayed values are '% of row' based on the underlying 'Count'
values which are not displayed.
When I try to sort the pivot table by these displayed '% of row' values it
sorts by un-displayed 'Count' instead. This is despite the fact that the
Summary section at the bottom of the sort dialog box suggests that it will
sort the list by the displayed '% of row' values.
Seems to me to be a bug. Does anyone know a workaround if so, or what I am
doing wrong if it is not a bug?
many thanks
Vin
PS - I already posted this in Excel section, but it doesn't seem to show up
when one browses to the excel message board top level. So thats why I
re-posted here in the excel-general section.