ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Problems with Pivot Table Field Sorting in Excel 2002 (https://www.excelbanter.com/excel-discussion-misc-queries/15248-re-problems-pivot-table-field-sorting-excel-2002-a.html)

Phoenix71555 February 27th 05 09:19 PM

Problems with Pivot Table Field Sorting in Excel 2002
 
I created a pivot table and in the data area I have 4 months of sales date
Jan, Mar, Jun, and Dec.. When I pull down the down arrow for this data I see
all 4 months and I see box for each month and a box for all. When I look at
Jan, and Mar and not all I loose the other months. What is wrong with the
table?

"Debra Dalgleish" wrote:

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.


Mike wrote:
Hi.. thanks for the response. The ADVANCED option under
FIELD SETTINGS gives AUTOSORT options of:

Manual
Ascending
Descending
Data Source Order

It's set at Manual, but the data is in Ascending order
even though the data in the original sheet is not sorted.
And, the "data source order" option is greyed out.

I still cannot get the data in the same order as the
original sheet. Any reason why the Data Source Order
would be greyed out?

Thanks again. Mike

-----Original Message-----
If you right-click on a field button, choose Field


Settings, and click

Advanced, that field should appear in the field list for


sort order.

Mike wrote:

I cannot get some data fields in pivot tables to

appear

in the "data source order". This option under advanced

is

greyed out for some reason. So everything gets sorted.
Any suggestions?


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

.




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



Debra Dalgleish February 28th 05 12:25 AM

Once you uncheck a data field, it's removed from the pivot table. To see
it again, you can drag the field back in from the field list


Phoenix71555 wrote:
I created a pivot table and in the data area I have 4 months of sales date
Jan, Mar, Jun, and Dec.. When I pull down the down arrow for this data I see
all 4 months and I see box for each month and a box for all. When I look at
Jan, and Mar and not all I loose the other months. What is wrong with the
table?

"Debra Dalgleish" wrote:


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.


Mike wrote:

Hi.. thanks for the response. The ADVANCED option under
FIELD SETTINGS gives AUTOSORT options of:

Manual
Ascending
Descending
Data Source Order

It's set at Manual, but the data is in Ascending order
even though the data in the original sheet is not sorted.
And, the "data source order" option is greyed out.

I still cannot get the data in the same order as the
original sheet. Any reason why the Data Source Order
would be greyed out?

Thanks again. Mike


-----Original Message-----
If you right-click on a field button, choose Field

Settings, and click


Advanced, that field should appear in the field list for

sort order.


Mike wrote:


I cannot get some data fields in pivot tables to

appear


in the "data source order". This option under advanced

is


greyed out for some reason. So everything gets sorted.
Any suggestions?


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

.



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





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



All times are GMT +1. The time now is 05:54 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
ExcelBanter.com