Home |
Search |
Today's Posts |
#1
|
|||
|
|||
pivot table in data source order
My pivot table report automatically sorts the data, rather than keeping it in
data source order, which is what I want. I click on the "Manual" option in the advanced section to no avail. The option button that says "Data source order" is greyed out so I cannot select that option. I am using Excel 2002 |
#2
|
|||
|
|||
AFAIK, the Data source option is only enabled for OLAP cubes. For pivot
tables built from Excel data, the items are listed in Ascending order when the pivot table is created. If you set sort to Manual, you can drag the items to any position in the list. You could also 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, select the field button, and choose DataSort Click the Options button, and choose your custom list. Murray wrote: My pivot table report automatically sorts the data, rather than keeping it in data source order, which is what I want. I click on the "Manual" option in the advanced section to no avail. The option button that says "Data source order" is greyed out so I cannot select that option. I am using Excel 2002 -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
Using Microsoft Query data in a pivot table. | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |