Hi Mike-

If I interpret you accurately, right-click the "button" caption (or one of
the row/column captions) for the row or column field that you want to change
the order of. Choose Field Settings & click the Advanced button to set
Ascending or Descending. Note, however, that if you leave it set for the
default of Manual you can also use Drag & Drop to arrange the order of the
columns & rows as you wish.

HTH |:)

"NJ_Mike" wrote:

Pivot table results are always in alphabectical order. Is there a way to
change this order. For example, I have a report set up that creates an
Income Statement with the first dimension being "Income" & "Expense".
Expense always comes before Income because E comes before I, but I want it
the other way around to reflect an actual Income Statement. Can this be done?