Order of Pivot Drop-Down (Page Field)
 

Hello!

I've tried searching, but to no avail...

I have a pivot table in Office 2003 with two 'page field' items. Say
it's colors: Page Field 1 would contain the following:
Blue 1
Yellow 1
Green 1
In the other page field, you must pick the corresponding color:
Blue 2
Yellow 2
Green 2

So, in the raw data, these 'colors' are listed in the exact same order,
like so:
Blue 1 | Blue 2
Yellow 1 | Yellow 2
Green 1 | Green 2


Say that it goes Blue 1, Yellow 1, Green 1 in Field 1. Well, for some
reason, it's pulling it in Field 2 as Yellow 2, Blue 2, Green 2. Not
alphabetically, but in the annoying random order.

Naturally, my real list is much longer so it's kind of confusing to
have to scroll and match 1 and 2. Plus, while it's not a problem for
me, this report is being sent to people with very limited computer
skills. Soo... is there a way for the Pivot *not* to reorder the fields
at all? To have it pull in the names in exactly the order it's in on
the data sheet? Both are set to "Manual" in the AutoSort field.

Any help or insight would be greatly appreciated. Hopefully, this made
some kind of sense!!