Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Values in Pivot Table
Excel 2007
I have 3 row fields and 2 data values. I'd like to sort the list by one of the data values, while keeping the row fields in tact. When I look in the help section, the instructions they provide don't do anything at all. Please help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Values in Pivot Table
Right click on the row field that you want sorted and select field settings.
Select advanced and then alter the sort by to the data field in question. -- HTH... Jim Thomlinson "Bruce" wrote: Excel 2007 I have 3 row fields and 2 data values. I'd like to sort the list by one of the data values, while keeping the row fields in tact. When I look in the help section, the instructions they provide don't do anything at all. Please help. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Values in Pivot Table
Thank you, Jim. However, it's not one of the row fields that I want to sort
on, it's one of the data values. I hope that I'm using the right term. Just in case I'm not, in a pivot table, I know of 3 different values - row fields, column fields and data fields. It's the data one I want to sort. Thank you. "Jim Thomlinson" wrote: Right click on the row field that you want sorted and select field settings. Select advanced and then alter the sort by to the data field in question. -- HTH... Jim Thomlinson "Bruce" wrote: Excel 2007 I have 3 row fields and 2 data values. I'd like to sort the list by one of the data values, while keeping the row fields in tact. When I look in the help section, the instructions they provide don't do anything at all. Please help. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Values in Pivot Table
Thank you! I have been (secretly) looking for that answer for months.
-- Mathieu "Jim Thomlinson" wrote: Right click on the row field that you want sorted and select field settings. Select advanced and then alter the sort by to the data field in question. -- HTH... Jim Thomlinson "Bruce" wrote: Excel 2007 I have 3 row fields and 2 data values. I'd like to sort the list by one of the data values, while keeping the row fields in tact. When I look in the help section, the instructions they provide don't do anything at all. Please help. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting Values in Pivot Table
In one of the row fields, right click and select "Advanced" and you will see
where you can sort ascending or descending and then specify at the bottom what data field to sort by (all fields, including data fields, should be available). The tricky thing for me is I like to sort by a data field in descending order but then sort the row field in ascending order, but it cannot do that (for example, I have a count of how many customers have a certain product but when I have 5 customers with the same product count, I prefer those 5 to show up in alphabetical order but have to settle for descending instead). -- Please remember to indicate when the post is answered so others can benefit from it later. "Bruce" wrote: Thank you, Jim. However, it's not one of the row fields that I want to sort on, it's one of the data values. I hope that I'm using the right term. Just in case I'm not, in a pivot table, I know of 3 different values - row fields, column fields and data fields. It's the data one I want to sort. Thank you. "Jim Thomlinson" wrote: Right click on the row field that you want sorted and select field settings. Select advanced and then alter the sort by to the data field in question. -- HTH... Jim Thomlinson "Bruce" wrote: Excel 2007 I have 3 row fields and 2 data values. I'd like to sort the list by one of the data values, while keeping the row fields in tact. When I look in the help section, the instructions they provide don't do anything at all. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Sorting | Excel Worksheet Functions | |||
Automatic Sorting of Top Ten values in a table | Excel Discussion (Misc queries) | |||
Pivot Table Sorting | Excel Discussion (Misc queries) | |||
Need help sorting pivot table | Excel Discussion (Misc queries) |