Home

Pivot Table Formatting

Highlighted
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.). 

Capture.PNG

4 Replies
Highlighted

hello

Try to change the Report layout to table format ,

Design > Report layout > Tabular formatnew1.PNG@Keetonct 

Highlighted

Hi @Keetonct ,

 

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

image.png

After that just drag Values into Rows area

image.png

After that Pivot Table will be as

image.png

 

Highlighted

@Sergei Baklan Thank you!

@Keetonct , you are welcome