Pivot Table Report formatting - can't select Data Source Order
 

Going a little bananas with trying to get a Pivot Table Report to accept the
order of the fields as they are in the Pivot Table. It's importing them in
ascending order by default, and I can't select Data Source Order from the
toolbar's Sort and Top 10/AutoSort options. The "manual" selection is the
default, but I don't want to have to drag every field around each time.
What's up?

The Data Source Order option applies to OLAP source data.

For pivot tables built from Excel data, the items are listed in
Ascending order when the pivot table is created. If you don't want to
sort the items manually, you could create a custom list, and base the
sort order on that.

In a cell on a blank worksheet, type your list, then select it
Choose ToolsOptions
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, set them to automatic
sort, or select the field button, and choose DataSort
Click the Options button, and choose your custom list.


Becky wrote:
Going a little bananas with trying to get a Pivot Table Report to accept the
order of the fields as they are in the Pivot Table. It's importing them in
ascending order by default, and I can't select Data Source Order from the
toolbar's Sort and Top 10/AutoSort options. The "manual" selection is the
default, but I don't want to have to drag every field around each time.
What's up?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html