Maintaining rows in a Pivot Table

S

Steve R

I have an Income Statement that has account numbers and subtotals. I want to
keep the hierarchy/order if possible but it seems when I put the data into a
pivot table that it puts everything in numerical order followed by
alphabetical.

So is there a way for it not to sort my account data?

Thanks,
Steve
 
D

Debra Dalgleish

You could create a custom list of your account numbers, and base the
sort order on that.

In a cell on a blank worksheet, type your list, then select it
Choose Tools>Options
Select the Custom Lists tab
Click the Import button, click OK

When you create a new pivot table, items should be in the order of the
custom list.

To sort the items in an existing pivot table, select the field
button, and choose Data>Sort
Click the Options button, and choose your custom list.
 
Top