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
|
Similar Threads
