Multi-sort in pivot

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Multi-sort in pivot

Post by Egg 'n' Bacon »

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

User avatar
HansV
Administrator
Posts: 78674
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multi-sort in pivot

Post by HansV »

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?
Best wishes,
Hans

Egg 'n' Bacon
5StarLounger
Posts: 736
Joined: 18 Mar 2010, 11:05

Re: Multi-sort in pivot

Post by Egg 'n' Bacon »

Not sure yet - just playing around with ideas :)

User avatar
HansV
Administrator
Posts: 78674
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Multi-sort in pivot

Post by HansV »

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