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

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

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

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