format excel pivot with group header

actsoft
actsoft used Ask the Experts™
on
formatting a excel pivot table for printBRomani-Comm1019.xlsx
I want the group header to display alone like the group footer in attached word doc
all other columns under the group header for space considerations
display.docx
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Tom FarrarConsultant

Commented:
When you say alone, are you saying on a line above the first line of data?    Not sure this can be done.  You can open up the column so the name shows (see example), but don't think you can move it up above the first line of data.
BRomani-Comm1019--EE.xlsx
You can place the subtotals above the group.
Right click, Field settings - Layout
BRomani-Comm1019.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial