Further options in the field list

Navigation:  Editing worksheets > Pivot tables > Starting with the pivot table field list >

Further options in the field list

Previous pageReturn to chapter overviewNext page

The field list includes other operating options that have not yet been described but are explained in more detail in the following sections:

Pivot table settings button:
Section Pivot table settings

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

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)