pivot-table.md

title	author	legacyId
Pivot Table	Natalia Kazakova	4846

Pivot Table

This section describes the capabilities provided by the Pivot Table, which represents data in a cross-tabulated form.

 

Data Editing

• Edit Data in Pivot Tables

  Describes how to edit cell values and regular expressions used to calculate these values.

• Edit Unbound Expression

  Describes how to edit the unbound field's expression.

 

Data Presentation

• Sort Data in Pivot Tables

  Describes how you can sort field values alphabetically or by summary values displayed in a particular column or row.

• Filter Data in Pivot Tables

  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.

• Apply Conditional Formatting

  Describes how to change the appearance of individual cells based on specific conditions.

• Change Summary Type in Pivot Tables

  Describes how to specify which calculations the Pivot Table should perform against its data.

• Pinned (Fixed) Columns

  Describes how to pin columns in the Pivot Table.

 

Layout Customization

• Expand and Collapse Groups in Pivot Tables

  Provides information on how to expand and collapse field values and field headers.

• Hide Pivot Table Fields

  Guides you through the process of hiding Pivot Table fields.

• Display Hidden Pivot Table Fields

  Describes how to display fields that have previously been hidden.

• Reorder Pivot Table Fields

  Provides information on how to reorder Pivot Table fields.

 

Selection and Navigation

• Select Cells in Pivot Tables

  Describes how to select a single or multiple cells, and copy their contents to the clipboard.

 

Field List

• Field List Overview

  Provides basic information about Field Lists.

• Invoke a Field List

  Describes how to invoke a Field List.

• Defer Pivot Table Updates

  Describes how to prevent automatic Pivot Table updates and force it to update manually.

• Change Field List Layout

  Provides information on how to change the layout of an advanced Field List.