How to Sort Grouped Data in Pivot Table?

[ticwang]

Hi,

Can anyone tell me how to sort the grouped data so the list will start with the largest value, instead of the smallest value?

For example, the Pivot Table's default sorting is:

-40000 - -30000
-30000 - -20000
-20000 - -10000
-10000 - 0
0 - 10000
10000 - 20000
20000 - 30000
30000 - 40000

I would like to change it to:

30000 - 40000
20000 - 30000
10000 - 20000
0 - 10000
-10000 - -20000
-20000 - -30000
-30000 - -40000

I have tried the ascending/descending sorting but Pivot Table ignores the negative sign and sorts the grouping with the first number of each group. I use manual sorting to get the list I want but it is kind of slow when the list gets bigger. Is there a faster way to do this?

Thank you,
Tracy