PivotSummaryFilter.RowField Property
Gets or sets the row field used to identify an aggregation level to which the filtering is applied.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.PivotGrid.v18.2.Core.dll
Declaration
Property Value
| Type | Default | Description |
|---|---|---|
| PivotGridFieldBase | *null* | A PivotGridFieldBase descendant that specifies the row field used to identify an aggregation level to which the filtering is applied. |
Remarks
Summary filtering cannot be simultaneously enabled for Totals, Grand Totals and data cells calculated against the same data field. It can only be applied to cells that belong to the same aggregation level.
By default, summary filtering is applied to cells that belong to the last level (a level identified by the last column and row fields). You can use the PivotSummaryFilter.ColumnField and RowField properties to specify other levels, except for the (Grand Total, Grand Total) level that consists of only one cell. To enable filtering at a specified level, you should also set the PivotSummaryFilter.Mode property to PivotSummaryFilterMode.SpecificLevel.
For more information about aggregation levels, see Aggregation Levels.
Assign the null (Nothing in Visual Basic) value to the RowField property to identify the Grand Total row.
Use the PivotSummaryFilter.ColumnField property to specify a column field that identifies the aggregation level.
If the PivotSummaryFilter.Mode property is set to PivotSummaryFilterMode.LastLevel, summary filtering is applied to cells that belong to the last level and the PivotSummaryFilter.ColumnField and RowField properties are not in effect.
As an alternative to specifying summary filter settings using properties exposed by the PivotSummaryFilter object, you can call an appropriate overload of the PivotSummaryFilter.Apply method and pass these settings as parameters.
To learn more, see Filtering by Summaries Overview and Using Summary Filters.
Related GitHub Examples
The following code snippet (auto-collected from DevExpress Examples) contains a reference to the RowField property.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.