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