At least as an option, allow fields to be ordered the same as the source query rather than alphabetical. This way they can be put in a logical and consistent order. Obviously, a workaround is to...
Usually in a pivot table field view you may choose to sort the fields alphabetically or data source order. However, if you also happen to hide any field from client tools, you may no longer sort in data source order, alphabetically only.
