Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Sort ???
I would like to sort a pivot table by one catagory within different groups. ie
Group / Sub group / Data A 1 100 2 200 3 300 B 1 300 2 200 3 100 How do I get group "B" to sort in an order other than the same order as group "A". It seems that the pivot table will only let me sort one group of data? Thanks so much for your help on this, Eric |
#2
|
|||
|
|||
Eric,
Do you want? A 1 100 2 200 3 300 B 3 100 2 200 1 300 If so, set the field setting of "Sub Group" to sort based on Data - click on the "Advanced" tab of the field setting dialog, the click Ascending on thesort, and choose "Sum of Data" from the choices. HTH, Bernie MS Excel MVP "Eric" wrote in message ... I would like to sort a pivot table by one catagory within different groups. ie Group / Sub group / Data A 1 100 2 200 3 300 B 1 300 2 200 3 100 How do I get group "B" to sort in an order other than the same order as group "A". It seems that the pivot table will only let me sort one group of data? Thanks so much for your help on this, Eric |
#3
|
|||
|
|||
I don't have the advanced option under the feild setting dialog box. I'm
running Excel 2000, I assume this was added in later versions. Thanks for your help, Eric "Bernie Deitrick" wrote: Eric, Do you want? A 1 100 2 200 3 300 B 3 100 2 200 1 300 If so, set the field setting of "Sub Group" to sort based on Data - click on the "Advanced" tab of the field setting dialog, the click Ascending on thesort, and choose "Sum of Data" from the choices. HTH, Bernie MS Excel MVP "Eric" wrote in message ... I would like to sort a pivot table by one catagory within different groups. ie Group / Sub group / Data A 1 100 2 200 3 300 B 1 300 2 200 3 100 How do I get group "B" to sort in an order other than the same order as group "A". It seems that the pivot table will only let me sort one group of data? Thanks so much for your help on this, Eric |
#4
|
|||
|
|||
Eric,
I think you do have that option, but not on the data field. You need to click on one of your row fields to get that option. HTH, Bernie MS Excel MVP "Eric" wrote in message ... I don't have the advanced option under the feild setting dialog box. I'm running Excel 2000, I assume this was added in later versions. Thanks for your help, Eric "Bernie Deitrick" wrote: Eric, Do you want? A 1 100 2 200 3 300 B 3 100 2 200 1 300 If so, set the field setting of "Sub Group" to sort based on Data - click on the "Advanced" tab of the field setting dialog, the click Ascending on thesort, and choose "Sum of Data" from the choices. HTH, Bernie MS Excel MVP "Eric" wrote in message ... I would like to sort a pivot table by one catagory within different groups. ie Group / Sub group / Data A 1 100 2 200 3 300 B 1 300 2 200 3 100 How do I get group "B" to sort in an order other than the same order as group "A". It seems that the pivot table will only let me sort one group of data? Thanks so much for your help on this, Eric |
#5
|
|||
|
|||
You Sir... are correct!
Thanks so much for your help, Eric "Bernie Deitrick" wrote: Eric, I think you do have that option, but not on the data field. You need to click on one of your row fields to get that option. HTH, Bernie MS Excel MVP "Eric" wrote in message ... I don't have the advanced option under the feild setting dialog box. I'm running Excel 2000, I assume this was added in later versions. Thanks for your help, Eric "Bernie Deitrick" wrote: Eric, Do you want? A 1 100 2 200 3 300 B 3 100 2 200 1 300 If so, set the field setting of "Sub Group" to sort based on Data - click on the "Advanced" tab of the field setting dialog, the click Ascending on thesort, and choose "Sum of Data" from the choices. HTH, Bernie MS Excel MVP "Eric" wrote in message ... I would like to sort a pivot table by one catagory within different groups. ie Group / Sub group / Data A 1 100 2 200 3 300 B 1 300 2 200 3 100 How do I get group "B" to sort in an order other than the same order as group "A". It seems that the pivot table will only let me sort one group of data? Thanks so much for your help on this, Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort a Column of Dates in Pivot Table | Excel Worksheet Functions | |||
pivot table sort entries that don't yet appear in table | Excel Discussion (Misc queries) | |||
Pivot Table Sort & Top List | Excel Discussion (Misc queries) | |||
I have two identical pivot tables with different sort order of th. | Excel Discussion (Misc queries) | |||
Sort in Pivot Table | Excel Worksheet Functions |