Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 27th 05, 09:19 PM
Phoenix71555
 
Posts: n/a
Default 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



  #2   Report Post  
Old February 28th 05, 12:25 AM
Debra Dalgleish
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a Pivot Table Calculated Field to get a Unique Count Mike Struckman Excel Worksheet Functions 1 November 22nd 05 06:32 PM
Pivot Table Page Field Jimbola Excel Discussion (Misc queries) 0 February 6th 05 10:13 PM
Problems with sorting a pivot table Gavim Francis Excel Discussion (Misc queries) 1 February 4th 05 12:32 AM
Calculated Field in Pivot Table Edgar Thoemmes Excel Worksheet Functions 0 December 23rd 04 12:59 PM
How to create a calculated field formula based on Pivot Table resu dha17 Excel Discussion (Misc queries) 1 December 15th 04 06:39 AM


All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017