View Single Post
  #1   Report Post  
marmur1
 
Posts: n/a
Default Can you reformat order of items in Pivot Tables after refresh?

When I set up pivot tables for time reporting entries at work, there are
often new projects that come in weekly, and every time that I refresh the
report, the new items do not show up in alphabetical order in the drop down
list (in the Page Field). Do any of you know if it's possible to reformat
the order of these items without having to rebuild the report?

I'm dealing with about 200 projects, and it becomes very difficult to sort
when new projects are added at the bottom while the rest are listed
alphabetically.

I'd GREATLY appreciate any ideas! : )