This section describes the capabilities provided by the Pivot Table, which represents data in a cross-tabulated form.
Describes how to edit cell values and regular expressions used to calculate these values.
Describes how to edit the unbound field's expression.
Describes how you can sort field values alphabetically or by summary values displayed in a particular column or row.
Provides information on how to filter data by hiding specific rows or columns via filter drop-down lists, and how to provide more advanced filtering by building a complex filter condition.
Describes how to change the appearance of individual cells based on specific conditions.
Describes how to specify which calculations the Pivot Table should perform against its data.
Describes how to pin columns in the Pivot Table.
Provides information on how to expand and collapse field values and field headers.
Guides you through the process of hiding Pivot Table fields.
Describes how to display fields that have previously been hidden.
Provides information on how to reorder Pivot Table fields.
Selection and Navigation
Describes how to select a single or multiple cells, and copy their contents to the clipboard.
Provides basic information about Field Lists.
Describes how to invoke a Field List.
Describes how to prevent automatic Pivot Table updates and force it to update manually.
Provides information on how to change the layout of an advanced Field List.