R
Renaud_D
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
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