Select the pivot table layout

From the Pivot Table Layout drop-down list, you can select one of the following layouts:

–Compact: Data for all fields in the Rows area is displayed in the first column of the pivot table in a hierarchical manner. The greater the nesting level of a field in the Rows area, the greater the indentation of its data in the first column of the table. The Compact layout is used for pivot tables by default.

–Tabular: Data of each field from the Rows area is displayed in a separate column. The column names correspond to the field names.

–Outline: Data of fields are arranged as in the Tabular layout, with each column displaying data one row lower than the previous one.