Field
Description
View
Click View to modify the items in the PivotTable Field List. Select from the following options:
Field Section and Areas Section Stacked — This is the default view, and it is designed for a small number of fields.
Fields Section and Areas Section Side-By-Side — This view is designed for adding and removing fields when you have more than four fields in each area.
Fields Section Only — This view is designed for adding and removing many fields.
Areas Section Only (2 by 2) — This view is designed for rearranging many fields.
Areas Section Only (1 by 4) — This view is designed for rearranging many fields.
Show fields related to
From the drop-down list, select all MPM fields available for reports or a subset of all the MPM fields to display in the PivotTable Field List.
The field list displays the measures and dimensions included in the MPM OLAP cube (external data) to which you connected after you opened Excel.
Field list
Scroll through the list to find an MPM field to add to the report.
MPM fields are divided into measures (numeric values) and dimensions (categories for sorting and grouping).
In the Field list, you can identify the measures and dimension fields as follows:
Measures have a Greek sigma symbol
in front of them.Dimensions have a Page symbol
in
front of them.
Report Filter
The Report Filter displays the filters that you applied to the entire report, not to specific dimensions or measures. Filters exclude data from a report.
Only dimensions can be selected as report filters.
The order of the report filters in the Report Filter area has no impact on the order of the data in the report.
To add report filters, from the list of fields in the PivotTable Field List, right-click a field name, and then on the shortcut menu, click Add to Report Filter.
Column Labels
By default, some measures that you select from the PivotTable Field List display in the Column Labels area. These fields also display as columns in the report layout area.
You can click and drag an item from the Column Labels area to the Row Labels area to have it placed as a row instead.
The order of the fields in the Column Labels area is the order in which the fields display in the report layout. You can click and drag fields to modify their order.
Row Labels
By default, dimensions that you select from the PivotTable Field List usually display in the Row Labels area. These fields also display as rows in the report layout area.
You can also click and drag an item from the Row Labels area to the Column Labels area to have it display as a column instead.
The order of the fields in the Row Labels area is the order in which the fields display in the report layout. You can click and drag fields to modify their order.
Values
Values displays numeric and calculated measures that you include in a report.
Dimensions cannot be values.
If more than one measure is added to a report, you see a Sum of Values label 
in the Column Labels
area by default. This does not have to be the last row or column.
The order of the measures in the Values area determines the order of the data in the report layout. You can click and drag fields to modify their order.
Defer Layout Update
As you create a report and make modifications in the PivotTable Field List, the Excel worksheet is automatically refreshed so that you immediately see the modified data in the report layout area. You can see the modification instantly, but if you use a large amount of report data, the refresh process may take longer than an instant.
To turn off the automatic refresh so you can control when the refresh process occurs, select the Defer Layout Update check box; then when you want to refresh the data, click the Update button to the right of the Defer Layout Update check box.