Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I create pivot table with just one label column?
In excel 2003 I make extensive use of pivot tables to make summaries.
What I've never found a way to do is have a single label column on the left for multiple levels. Eg, if I create a table by Department and Service on the left I always get: Column1 - Department Column 2 - Service When I really want a single column more like sub totals: Column1 Service Service Department Total Service Service Department Total This is much more compact for presenting in documents, but I have to manually adjust it into this format. Am I missing any trick to get pivots to change to such a layout? Any help appreciated. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table (column/row) label cache reset | Excel Discussion (Misc queries) | |||
Calculated column label in pivot table? | Excel Discussion (Misc queries) | |||
Pivot Table Column Label: Multiple color font on selected word? | Excel Worksheet Functions | |||
Create subtotal column in pivot table | Excel Discussion (Misc queries) | |||
How to delete column label from pivot table field | Excel Worksheet Functions |