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:

DOWNLOAD EXCEL WORKBOOK

 

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

Compact Form

compact pivot table

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

OUTLINE

outline pivot table

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

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

tabular

tabular pivot

 

HELPFUL RESOURCE:

Xtreme Pivot TAble Course

4

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