Sorting 2 data columns in Pivot Table
Thanks for your reply Shane
Too bad that there is no two level sort
I did use the manual option
the problem is that sometimes the table will have 30+ rows
and to arrange manually it´s going to take a lot of time
perhaps the only way is to copy-paste as values
and the do the sort
"Shane Devenshire" wrote:
Hi,
Well that's a nice idea, but within the pivot table there is no automatic
command to do a two level sort. What you want can be done, but manually as
follows:
In your example, select the cell in the pivot table with B, place your mouse
along the edge until you see a four headed arrow, then drag upward.
--
If this helps, please click the Yes button.
Cheers,
Shane Devenshire
"Alonso" wrote:
Hi everybody
I have a pivot table with 2 datas (HI and LOW) for each row
I want to sort them descending on BOTH columns -when HI has the same value
for 2 or more items, then sort them descending by LOW
So far I can only arrange them by HI
and keep getting a table like this:
Number Name HI LOW
1 A 900 900
2 B 900 850
3 C 900 880
4 D 800 700
5 E 800 750
So, I need that C should be above B
and E above D
I have try the Z-A button on HI and then LOW
and also clicking on Number-More sort options-Descending by HI
but can't make the pivot table do what i want
is this possible??
I'm using EXCEL 03
|