Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
Hi there was wondering if anyone can help me..
I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
You can try a couple of things:
Option#1: Double-click the first Row field button Click the Advanced button For AutoSort, choose Descending From the Using Field dropdown, select the data field, e.g. "Sum of Units" Click OK, click OK. Option#2: 1. Select the entire pivot table 2. Copy it and paste it Value elsewhere. 3. The copy is a simple table and can be sorted using normal approaches Hope it helps, Ryan--- -- RyGuy "Scott R" wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
Sorry Guys Im usually pretty good with pivot tables, but I dont understand
either of these options that I have been given.. Can anyone help me with my original problem? "ryguy7272" wrote: You can try a couple of things: Option#1: Double-click the first Row field button Click the Advanced button For AutoSort, choose Descending From the Using Field dropdown, select the data field, e.g. "Sum of Units" Click OK, click OK. Option#2: 1. Select the entire pivot table 2. Copy it and paste it Value elsewhere. 3. The copy is a simple table and can be sorted using normal approaches Hope it helps, Ryan--- -- RyGuy "Scott R" wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
Just to clarify..
If I use Option 1 and dopuble click the first row then my entire pivot table disappears bar one line.. If I copy and past (option 2) I cant sort 'normally' as I need to sort within each site. "Scott R" wrote: Sorry Guys Im usually pretty good with pivot tables, but I dont understand either of these options that I have been given.. Can anyone help me with my original problem? "ryguy7272" wrote: You can try a couple of things: Option#1: Double-click the first Row field button Click the Advanced button For AutoSort, choose Descending From the Using Field dropdown, select the data field, e.g. "Sum of Units" Click OK, click OK. Option#2: 1. Select the entire pivot table 2. Copy it and paste it Value elsewhere. 3. The copy is a simple table and can be sorted using normal approaches Hope it helps, Ryan--- -- RyGuy "Scott R" wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
I have now undersrtood what was meant in option 1 however this does not work.
When I click advanced it only gives me the option to sort by site or sum of the amount. I actually need to sort by 2007 which is 1 of the 2 year columns in my data area. There is no option for this. "Scott R" wrote: Just to clarify.. If I use Option 1 and dopuble click the first row then my entire pivot table disappears bar one line.. If I copy and past (option 2) I cant sort 'normally' as I need to sort within each site. "Scott R" wrote: Sorry Guys Im usually pretty good with pivot tables, but I dont understand either of these options that I have been given.. Can anyone help me with my original problem? "ryguy7272" wrote: You can try a couple of things: Option#1: Double-click the first Row field button Click the Advanced button For AutoSort, choose Descending From the Using Field dropdown, select the data field, e.g. "Sum of Units" Click OK, click OK. Option#2: 1. Select the entire pivot table 2. Copy it and paste it Value elsewhere. 3. The copy is a simple table and can be sorted using normal approaches Hope it helps, Ryan--- -- RyGuy "Scott R" wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
You can do that kind of sort in Excel 2007, but not in earlier versions.
Scott R wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table Sorting
ok thanks for that.
"Debra Dalgleish" wrote: You can do that kind of sort in Excel 2007, but not in earlier versions. Scott R wrote: Hi there was wondering if anyone can help me.. I have a pivot table with columns; A B C D E Site Client 2007 total 2008 total Grand Total I am trying to sort the entire pivot table by column C descending for each Site. If i use sort it only sorts the first site. If i manually go into each site and select the range then sort column c desc it unsorts the previous Site range. I could paste into new sheet and manuallysort each site but there are a lot of sites and would be great if i could automate this.. any suggestions would be appreciated... -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PIVOT Table Sorting - PLEASE Help!!!!! | Excel Discussion (Misc queries) | |||
Pivot Table Sorting | Excel Worksheet Functions | |||
Sorting / Pivot Table | New Users to Excel | |||
Pivot Table Sorting | Excel Discussion (Misc queries) | |||
Need help sorting pivot table | Excel Discussion (Misc queries) |