Customize pivot table settings

1.Click the Constructor tab.

2.Click the Select data source button next to the Source field.

3.In the window that opens, enter a new data range or select it with the mouse.

4.Confirm the changes by pressing OK or the Enter key.

On the Options tab, three options are available in the Pivot table layout list:

–Compact (default layout): all data from the Rows area is displayed in a single column with hierarchical indents for each nesting level.

–Tabular: each field from the Rows area is displayed in a separate column with its own header.

–Outline: the data is arranged as in a tabular layout, but each new column starts a row below the previous one.

By default, the table shows totals for rows (last column) and columns (last row).

To hide or show totals for columns/rows, use one of the methods:

–On the Options tab, under Grand totals, check or uncheck the For columns/rows check box.

–Right-click any cell in the table, select Show grand totals, then select or clear the For columns/rows check box.

You can control the display of totals for individual groups of data.

–Enable/disable: under Subtotals, select or clear the Display check box.

–Location selection (available for Compact and Outline layouts):

•Under the group — a row with totals is added under each group.

•In group header — totals are displayed directly in the group header row.

In the Tabular layout, subtotals are always displayed under the data group.

In the Captions section, you can set custom texts for various elements. Do not use formulas or functions in these fields.

Available caption fields

Change caption text

–To enter a new value, click a field and start typing, then press Enter.

–To clear an existing value, select and delete it, then press Enter.