Configure the pivot table settings

If you want to edit the pivot table data source, follow these steps:

1.Go to the Constructor in the pivot table settings pane.

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

3.Edit the value in the Source field and press the OK button or the Enter ( Enter) key.

In the Parameters tab in the Pivot table layout drop-down list you can choose one of the following layouts:

•Compact: The data of all fields from the Rows area is displayed in the first column of the pivot table and has a hierarchical structure. The higher the nesting level of a field in the Row 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:The data of each field from the Row area is displayed in a separate column. The column names correspond to the field names.

•Outline: The field data is arranged as in a Tabular layout, while in each column the data is displayed one row lower than the previous one.

By default, the last row of the pivot table displays the total column values, and the last column displays the total row values.

To hide or redisplay the total column values, use one of the following methods:

•In Parameters tab, in the Grand totals section, clear or select the For columns box.

•Right-click on any cell in the pivot table to open the context menu and select Show grand totals. In the sub-menu that opens, clear or select the box For columns.

To hide or redisplay the row totals, use one of the following methods:

•In Parameters tab, in the Grand totals section, select or clear the For rows box.

•Right-click on any cell in the pivot table to open the context menu and select Show grand totals. In the sub-menu that opens, clear or select the box For rows.

In the pivot table, you can do the following:

•Show or hide subtotals for each data group.

•Change where subtotals are displayed when a pivot table is set to the Compact or Structure layout. In a table with a Tabular layout, subtotals are always displayed under a group of data.

To hide or display subtotals, in the Subtotals section, clear or select the Display box.

In the Location drop-down list, select where the subtotals are displayed:

•Under the group: A string of the type Group_title Subtotal is displayed under each data group.

•In the group title:The subtotals are displayed in rows with the headings of the data groups.

In the Captions section, you can edit the names of some columns and rows in the pivot table, as well as specify the text to be displayed in empty cells or cells with errors.

The Captions section contains the following fields:

•Empty cells: The text to display in the empty cells of the pivot table.

•Errors: The text to display in cells that contain errors in calculations.

•Grand total: The name of the row and column with the grand total values.

•Values: This field is not used in this version of the application.

•Rows: The name of the rows in the pivot table with a compact layout.

•Columns: The name of the columns in a pivot table with a compact layout.

If there is no value in the field, enter the value manually and press the Enter ( Enter) key. If there is a value in the field, delete it manually, then enter the desired value and press the Enter ( Enter) key.