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
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
IIS extension is not working - WAC 1909
HotCakeX in Windows Admin Center on
11 Replies