Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting 2 data columns in Pivot Table
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting 2 data columns in Pivot Table
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting data in pivot table | Excel Discussion (Misc queries) | |||
Sorting multiple columns (fields) in a pivot table | Excel Discussion (Misc queries) | |||
Pivot table data sorting | Excel Discussion (Misc queries) | |||
Sorting by a 'data' column in a Pivot Table | Excel Discussion (Misc queries) | |||
Sorting Data in a Pivot Table | Excel Discussion (Misc queries) |