| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table multiple column fields
No, the outer column field can't be ignored to sort by the the second
column. You'll have to move workstation location to the left if you want to sort by that. Natalie wrote: Hi, I have a pivot table with multiple column fields: Part number, warehouse location, workstation location. I would like to display the fields in the order shown above (from left to right) but would like to sort the data by workstation location. Is there any function that can help me sort in this way? I tried the sort function but it only sorts the first column. I'm using Excel 2007. Would appreciate any help. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Fields In Multiple Ranged Pivot Table | Excel Discussion (Misc queries) | |||
| Drag multiple fields into data of pivot table | Excel Worksheet Functions | |||
| Adding multiple fields to a Pivot table at one time | Excel Discussion (Misc queries) | |||
| refresh of pivot table clears fields (column headers) | Excel Discussion (Misc queries) | |||
| Pivot Table with Multiple Row Fields | Excel Discussion (Misc queries) | |||
Threaded Mode
