Sorting a Pivot Table Column that is not the first column...

  • Thread starter Thread starter susanohkwon
  • Start date Start date
S

susanohkwon

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!
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Sorting 6
Sorting 2 data columns in Pivot Table 2
Sorting the pivot table field list 4
Sorting day names chronologically 5
sorting column with blanks 1
Sorting a Pivot Table 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Sort column beginning with blank? 1

Back
Top