Pivot Table

The Pivot Table is a data bound control that provides maximum capabilities for organizing, summarizing and analyzing your business data.

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 a more advanced filtering by building a complex filter condition.

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.

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.