Pivot table not sorted... "Data source order" not awailable

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pgchop - 23 Jan 2006 14:21 GMT

I use a pivot table in which I have some Row field columns (grouping) and
some Column field columns (data).

Row field columns (grouping):
Big Group : text
ABC : text
Article No: text starting with article number like "10/7001-20 |WG

|A|GE|AA"

Column field columns (data):
sum of open orders : integer
...

I understand I can specify in the Field Setting:Advanced:Autosort options to
sort within each "Big group", each "ABC", all "Article No" Ascending, using
field "sum of open orders".
If I do this, the sorting is done properly, according to the data column.

The other options are "Manual" and "Data source order"

The "Data source order" is not awailable and is dimmed. Why ???

And if I specify "Manual" (or dont specify any sorting) in the data column
the result is not always sorted according to the data source...
How can I ensure that within each "big group", each "ABC", all "Article No"
will be sorted alphabetically ???

I thought that if I don't specify anything, they would appear in the same
otder as in the excel database... that is already sorted top down or bottom
up...
but they are not sorted at all... Why ???

I don't get it... can anybody help ?

Thanks,
pg

Reply to this Message

Peter Aitken - 23 Jan 2006 16:33 GMT

>I use a pivot table in which I have some Row field columns (grouping) and
> some Column field columns (data).
[quoted text clipped - 19 lines]
>
> The "Data source order" is not awailable and is dimmed. Why ???

The data source must support this option for it to be available.

> And if I specify "Manual" (or dont specify any sorting) in the data column
> the result is not always sorted according to the data source...

Manual means that you can sort items manually by dragging them.

> How can I ensure that within each "big group", each "ABC", all "Article
> No"
> will be sorted alphabetically ???

Select Ascending as the sort option for that field.

> I thought that if I don't specify anything, they would appear in the same
> otder as in the excel database... that is already sorted top down or
> bottom
> up...
> but they are not sorted at all... Why ???

PTs don't always work the way you think they should. Specify the desired
sort, do not expect it to happen automatically.

Signature

Peter Aitken

Remove the crap from my email address before using.

Reply to this Message

pgchop - 23 Jan 2006 17:03 GMT

Thanks Peter but it does not help.
In a pivot table you can only sort on the column fields (data).
The "Article No" is a text field in the Row fields (i.e. the grouping = left
side)

Thanks anyway, any other ideas... ?

PS: By the way, my data source is an other excel file... I guess sorting is
awailable
-----------------------
"Peter Aitken" a écrit :

> > How can I ensure that within each "big group", each "ABC", all "Article
> > No"
> > will be sorted alphabetically ???
>
> Select Ascending as the sort option for that field.

Reply to this Message

Peter Aitken - 23 Jan 2006 21:18 GMT

Sure you can - in Excel 2003 anyway. Right-click the field button and select
Field settings from the popup menu, then click the Advanced button. You'll
see

Signature

Peter Aitken

Remove the crap from my email address before using.

> Thanks Peter but it does not help.
> In a pivot table you can only sort on the column fields (data).
[quoted text clipped - 15 lines]
>>
>> Select Ascending as the sort option for that field.

Reply to this Message