How to change report formats in Excel

From my last blog, I have mentioned how to create pivot table in excel. Now, let’s go through different kinds report formats in Excel pivot table.

There are three types of report formats in Excel Pivot Table:

  1. Compact Form
  2. Outline Form
  3. Tabular Form

Suppose we have a pivot table with the following report fields.

Pivot Field Table

Following is the layout for each report formats in Excel.

Compact Form

Change Pivot Table report to Compact Form (Design Ribbon for Pivot Table)
Change Pivot Table report to Compact Form (Design Ribbon for Pivot Table)

Pivot Table report in Compact Form
Pivot Table report in Compact Form

All row fields are in the same column.

Outline Form

Change Pivot Table report to Outline Form
Change Pivot Table report to Outline Form

Pivot Table in Outline Form
Pivot Table in Outline Form

All Row Field are in separate columns a second row field start after the first row field. First column of the first row field is by default a summary of all values from the second row field.

Tabular Form

Change Pivot Table report to Tabular Form
Change Pivot Table report to Tabular Form (Design Ribbon for Pivot Table)

Pivot Table report in Tabular Form
Pivot Table report in Tabular Form

All Row Field are in separate columns a second-row field start after the first-row field. Total column for first-row field is placed to the bottom of the row.

Leave a Comment