View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Supe Supe is offline
external usenet poster
 
Posts: 59
Default Pivot Table Sort

Is it possible to sort two columns in descending order in a Pivot Table where
the second column would sort in descending order after the first column gets
down to zero. For Example the data below..


1st Column 2nd Column
4 1
2 2
0 5
5 7
0 1
0 2


Would Sort Like

1st Column 2nd Column
5 2
4 7
2 1
0 5
0 2
0 1