Is it possible to have more than one stage of sorting in a pivot table?
For example;
First level might be costs,
Second level could be distance.
TIA
Multi-sort in pivot
-
- Administrator
- Posts: 78674
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multi-sort in pivot
By default, the values of the row labels and column labels will be sorted. If you have two levels of row labels, the outer level is sorted first, and the inner level within each value of the outer level.
What exactly do you want to accomplish?
What exactly do you want to accomplish?
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 736
- Joined: 18 Mar 2010, 11:05
Re: Multi-sort in pivot
Not sure yet - just playing around with ideas :)
-
- Administrator
- Posts: 78674
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Multi-sort in pivot
I'd need to have more specific information, as it is it's not clear to me what you want above/beyond the default sorting in a pivot table.
Best wishes,
Hans
Hans