| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table multiple column fields
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. |
| 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
