Pivot Table Formatting

New Contributor

Looking to understand how to format a pivot table like in the screenshot below. Not sure on how to create the sub headings underneath the main headers ("Average of Median Wage," "Average of Employment Diff," etc.). 


4 Replies


Try to change the Report layout to table format ,

Design > Report layout > Tabular formatnew1.PNG@Keetonct 

Hi @Keetonct ,


Let me illustrate on simple sample. If we start from Pivot Table in default outlined form


After that just drag Values into Rows area


After that Pivot Table will be as




@Sergei Baklan Thank you!

@Keetonct , you are welcome

Related Conversations
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies
Set Auto Refresh to Pivot Table as Source Data Changes
ratishkp in Excel on
2 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
conditional formatting with formula
kdwork in Excel on
3 Replies
Conditional Formatting - Consider Only Value as Lowest Value
Ben Smith in Excel on
2 Replies
Date Formatting Won't Change
Steve Gould in Excel on
10 Replies