De-nesting sorting in PivotTable
 

Hello,

I'm struggling with a sort operation in a pivotTable. I'm tracking a
variable (bids) over a serie of items defined by several attributes. My goal
is to produce a table that will list the items, grouped by one or several of
the parameters, in decreasing value of the variable. However, when I setup
the table and try to sort on the variable, PivotTable persistently "nests"
the sortings of the value.

Hence, if I sort the records grouped by the first parameter, the list is
fine. If I want to show more item details and therefore add another row
labels (a 2nd attribute, thus), the sorting doesn't happen at the lowest
level of details but first at the level of the 1st attribute, then within
this 1st level, according to the second one, etc, instead of sorting the
records from the lowest level.

To better illustrate this, a sample of the data and the table are located
here in this file:

http://www.dainville.be/pivot_test.xls

Thanks in advance for your precious input.

Cheers,

Renaud

De-nesting sorting in PivotTable
 

If you leave just the first field in the row area, and add other fields
to the column area, you can sort on the grand total column.

Renaud_D wrote:
Hello,

I'm struggling with a sort operation in a pivotTable. I'm tracking a
variable (bids) over a serie of items defined by several attributes. My goal
is to produce a table that will list the items, grouped by one or several of
the parameters, in decreasing value of the variable. However, when I setup
the table and try to sort on the variable, PivotTable persistently "nests"
the sortings of the value.

Hence, if I sort the records grouped by the first parameter, the list is
fine. If I want to show more item details and therefore add another row
labels (a 2nd attribute, thus), the sorting doesn't happen at the lowest
level of details but first at the level of the 1st attribute, then within
this 1st level, according to the second one, etc, instead of sorting the
records from the lowest level.

To better illustrate this, a sample of the data and the table are located
here in this file:

http://www.dainville.be/pivot_test.xls

Thanks in advance for your precious input.

Cheers,

Renaud


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

De-nesting sorting in PivotTable
 

.... and it worked fine!

Merci beaucoup! Thank a lot!

"Debra Dalgleish" wrote:

If you leave just the first field in the row area, and add other fields
to the column area, you can sort on the grand total column.

Renaud_D wrote:
Hello,

I'm struggling with a sort operation in a pivotTable. I'm tracking a
variable (bids) over a serie of items defined by several attributes. My goal
is to produce a table that will list the items, grouped by one or several of
the parameters, in decreasing value of the variable. However, when I setup
the table and try to sort on the variable, PivotTable persistently "nests"
the sortings of the value.

Hence, if I sort the records grouped by the first parameter, the list is
fine. If I want to show more item details and therefore add another row
labels (a 2nd attribute, thus), the sorting doesn't happen at the lowest
level of details but first at the level of the 1st attribute, then within
this 1st level, according to the second one, etc, instead of sorting the
records from the lowest level.

To better illustrate this, a sample of the data and the table are located
here in this file:

http://www.dainville.be/pivot_test.xls

Thanks in advance for your precious input.

Cheers,

Renaud


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

De-nesting sorting in PivotTable
 

Bienvenue! Thanks for letting me know that it worked.

Renaud_D wrote:
... and it worked fine!

Merci beaucoup! Thank a lot!

"Debra Dalgleish" wrote:


If you leave just the first field in the row area, and add other fields
to the column area, you can sort on the grand total column.

Renaud_D wrote:

Hello,

I'm struggling with a sort operation in a pivotTable. I'm tracking a
variable (bids) over a serie of items defined by several attributes. My goal
is to produce a table that will list the items, grouped by one or several of
the parameters, in decreasing value of the variable. However, when I setup
the table and try to sort on the variable, PivotTable persistently "nests"
the sortings of the value.

Hence, if I sort the records grouped by the first parameter, the list is
fine. If I want to show more item details and therefore add another row
labels (a 2nd attribute, thus), the sorting doesn't happen at the lowest
level of details but first at the level of the 1st attribute, then within
this 1st level, according to the second one, etc, instead of sorting the
records from the lowest level.

To better illustrate this, a sample of the data and the table are located
here in this file:

http://www.dainville.be/pivot_test.xls

Thanks in advance for your precious input.

Cheers,

Renaud


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html