Further options in the field list

<< Click to Display Table of Contents >>

Further options in the field list

In the field list you will find further control elements not described here. These are explained more closely in the following sections:

Pivot table settings button:
Section Pivot table settings

Refresh data button:
Section Updating pivot tables and changing data range

Defer layout update along with the Update button:
Section Defer layout update

Field settings (via dropdown menu dropdown_arrow of fields in the row labels/column labels area):
Section Field settings (Row/column labels area)

Filter labels (via dropdown menu dropdown_arrow of fields in the row labels/column labels area):
Section Sorting and filtering pivot tables

Filter values (via dropdown menu dropdown_arrow of fields in the report filter area):
Section Sorting and filtering pivot tables

Value settings (via dropdown menu dropdown_arrow of fields in the value area):
Section Value settings (Values area)