Need to sort my pivot tables

[Bill-E-BoB]

I have built a macro that compiles a list of all orders my company has currently pending and their age, then builds a pivot table for a quick snapshot of orders by day. The problem is, the pivot table puts the dates up in random order. For example, my sample data has orders aged 6,3,2,1 and 0 days. Then it builds my list like this:

DAYS:
3-
1-
2-
0-
6-

But I want it like this:
DAYS:
6-
3-
2-
1-
0-

It won't let me sort the table, and the real volumes will be MUCH too high for me to manually go through the pivot table & click & drag each value to the order I want it in...is there some way I can sort this?

[Bill-E-BoB]

Nevermind, I figured it out. If anyone else ever needs to do the same thing: Here's how:

1)build your pivot table.
2)right click on one of the row headers
3)Click "Fied Settings"
4)Click "Advanced..."
5) In the lower left side of the dialog box that pops up, you'll see that the autosort feature defaults to "manual". You can change it to ascending or descending from there.