How do I change the order of my pivot table?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
In your source table REVERSE the order of the information == DATA > SORT >
[Column that determines Income or Expense Item] > DESCENDING.

Close your Excel file, then re-open.
 
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 |:>)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arranging row titles in a Pivot Table 1
pivot tables 1
Maintaining rows in a Pivot Table 1
Pivot Table Sort Order 1
Dynamically changing several pivot tables at once 3
Pivot Table Set Up 2
How can I change the source data reference to another pivot table? 2
Question on the occupied field of the pivot table in excel spreadsheet 0

Back
Top