Pivot Table / Analyzer

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference >

Pivot Table / Analyzer

Interface Elements for Desktop > Pivot Table

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

img9062

 

Data Editing

Edit Data in Pivot Tables

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

Editing 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.

 

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.

Copyright (c) 1998-2016 Developer Express Inc. All rights reserved.

Send Feedback on this topic to DevExpress.