Would it be practical to create a lookup table for Career Level that would
prepend a sorting field? After importing the data, use a helper column to
create a display career level.

Example:
Level€¢€¢€¢€¢€¢€¢€¢€¢€¢DisplayLevel
-------------- -------------------
Manager€¢€¢€¢€¢€¢€¢001_Manager
Consultant€¢€¢€¢€¢002_Consultant
Specialist€¢€¢€¢€¢€¢003_Specialist
Analyst€¢€¢€¢€¢€¢€¢€¢004_Analyst

Then the pivot table would sort properly without manual intervention.

Does that help?

€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron


"rachael" wrote:

I have a pivot table that's accessing an ODBC data source. There's a field
for career level in the table that's currently sorted alphabetically. I'd
like to sort it in order of career level, instead. I'd need to do this
manually, because there is no simple alphabetic progression i can use. The
problem is, the table must be filtered on a single location (a page filter)
because there's so much data and while filtered not all career levels appear.
One location may show 2 career levels, another country may show 3, another
may show only 1.

How can i set this up to change the career level field from:
Analyst
Consultant
Manager
Specialist

to:
Manager
Consultant
Specialist
Analyst

Thanks
rachael