Pinterest Pixel

Pivot Table Report Layouts

Pivot Tables have three different layouts that you can choose from: Compact, Outline and Tabular Form. You... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Pivot Table Report Layouts | MyExcelOnline

Pivot Tables have three different layouts that you can choose from: Compact, Outline and Tabular Form.

You can choose from each layout by clicking in the Pivot Table and going to PivotTable Tools > Design > Report Layouts

They each have their advantages and disadvantages and I will show you what each one of them provide below:

Pivot Table Report Layouts | MyExcelOnline

Download excel workbookReport-Layouts.xlsx

 

COMPACT LAYOUT (New in Excel 2010)

Advantages: Optimizes for readability; Keeps related data in one column

Disadvantages: If you copy and paste the data into a new worksheet it will be harder to do further analysis

Pivot Table Report Layouts

Pivot Table Report Layouts

OUTLINE LAYOUT

Advantages: Includes Field headers in each column; Can Repeat All Item Labels; Can reuse the data of the Pivot Table to a new location for further analysis; Classic Pivot Table style

Disadvantages: Takes too much horizontal space

Pivot Table Report Layouts

Pivot Table Report Layouts

TABULAR LAYOUT

Advantages: Includes Field headers in each column; Can Repeat All Item Labels; See all data in a traditional table format used in Pivot Tables since their invention; Can reuse the data of the Pivot Table to a new location for further analysis

See also  Month over Month Comparison Charts in Excel Pivot Tables

Disadvantages: Takes too much horizontal space; Subtotals can never appear at the top of the group

Pivot Table Report Layouts

Pivot Table Report Layouts

 

HELPFUL RESOURCE:

Pivot Table Report Layouts

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Pivot Table Report Layouts | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!