Thread
:
Sorting a Pivot Table Column that is not the first column...
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
external usenet poster
Posts: 2,979
Sorting a Pivot Table Column that is not the first column...
You can sort the second column, but it will only sort within each group.
For example, if the first column is Region, and the second column is
City, you can sort the Cities within each region.
The region order won't be affected by the City sort.
wrote:
Is there a way that I can sort by a column in a Pivot Table that is
not the first column? The sort option works only for the first option
and does not work when I try to sort by any other column.
Thanks!
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Reply With Quote
Debra Dalgleish
View Public Profile
Find all posts by Debra Dalgleish