| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
PIVOT TABLE - MULTIPLE RANGES (ITEMS' SORTING)
I hae created a pivot table with multiple consolidation ranges from 10
different sheets. The page field is showing these sheets as ITEM 1, 2, 3 and so on! How can I have the sheet names appearing instead of ITEM 1, 2, 3? The ITEM 1, 2, 3 are also not being moved in an order that I require e.g. sheet "Jan" is required as the first item and sheet "Dec" is required as the last item Please help! -- Best Regards, FARAZ A. QURESHI |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table from multiple ranges? (Revisited) | Excel Discussion (Misc queries) | |||
| Pivot Table - Dragging multiple items into data field | Excel Discussion (Misc queries) | |||
| Pivot Table-Multiple Consolidation Ranges | Excel Discussion (Misc queries) | |||
| Orientation of multiple data items in Pivot table | Excel Discussion (Misc queries) | |||
| Pivot Table-Using Multiple SS's or Ranges? | Excel Discussion (Misc queries) | |||
Hybrid Mode
