pivot field order
 

Using 2007 - I have a pivot table with ten fields. When I create the pivot
table it automatically puts the fields in alpha order. I manually move them
into the order I need.

1) How can I do this programatically? This pivot table gets created weekly.
2) How can I add color to certain fields automatically? (ie. field WIP =
yellow, CXLD = purple, etc.)

Any help will be greatly appreciated!
--
Maritza