format excel pivot with group header

actsoft used Ask the Experts™
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
Watch Question

Do more with

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

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.
You can place the subtotals above the group.
Right click, Field settings - Layout

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