Filter Data in Pivot Tables

<< Click to Display Table of Contents >>

Navigation:  User Interface Reference > Pivot Table / Analyzer > Data Presentation >

Filter Data in Pivot Tables

Interface Elements for Desktop > Pivot Table > Data Presentation > Filter Data in Pivot Tables

By default, the Pivot Table processes all records when calculating its values. Data filtering allows you to process only those records that meet your requirements.

Topics in this section describe three ways of filtering data in Pivot Tables - filtering by field values, filtering by cell values and building complex filter criteria.

The following sections and topics are available.

Filter Data by Field Values

Contains topics that describe how to specify simple filter conditions via Filter Windows.

Filter Data by Cell Values

Contains topics that describe how to specify which cell values to display and which to hide.

Build Complex Filter Criteria

Describes the Prefilter feature that allows you to build complex filter criteria.

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

Send Feedback on this topic to DevExpress.