old A: What are the three layout options?

The exercise below uses the 10ab_Movies.xlsx file.

The data in an Excel PivotTable can be laid out in any of the following three layouts: Compact Form, Outline Form, or Tabular Form.

Compact Form

This layout display all the rows in the same column, and places subtotals at the top of the group.

Figure 164: Compact form

Figure 164: Compact form

Outline Form

This layout display each row field in its own column, and places the subtotals at the top of the group.

Figure 165: Outline form

Figure 165: Outline form

Tabular Form

This layout display each row field in its own column, and places the subtotals at the bottom of the group.

Figure 166: Tabular form

Figure 166: Tabular form

To change the layout format, do the following:

  1. Click anywhere within your PivotTable.
  2. From the ribbon choose PivotTable Tools, Design, Report Layout and then choose one of the following options.
  • Show in Compact Form
  • Show in Outline Form
  • Show in Tabular Form
    Figure 167: Report Layout drop down

    Figure 167: Report Layout drop down