<< Click to Display Table of Contents >> Navigation:  User Interface Reference > Analyzers

 

This section describes the capabilities provided by the Analyzers, 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.