PivotGridOptionsOLAP.DefaultMemberFields Property

Gets or sets for which filter fields the pivot grid processes only data related to their default members.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v20.2.Core.dll

Declaration

[DefaultValue(PivotDefaultMemberFields.NonVisibleFilterFields)]
public PivotDefaultMemberFields DefaultMemberFields { get; set; }
<DefaultValue(PivotDefaultMemberFields.NonVisibleFilterFields)>
Public Property DefaultMemberFields As PivotDefaultMemberFields

Property Value

Type Default Description
PivotDefaultMemberFields

NonVisibleFilterFields

A PivotDefaultMemberFields enumeration member that specifies for which filter fields the pivot grid processes only data related to their default members.

Property Paths

You can access this nested property as listed below:

Library Object Type Path to DefaultMemberFields
WinForms Controls PivotGridControl
.OptionsOLAP.DefaultMemberFields
ASP.NET Controls and MVC Extensions ASPxPivotGrid
.OptionsOLAP.DefaultMemberFields
MVCxPivotGrid
.OptionsOLAP.DefaultMemberFields
PivotGridSettings
.OptionsOLAP.DefaultMemberFields
Reporting XRPivotGrid
.OptionsOLAP.DefaultMemberFields

Remarks

In OLAP mode, data is filtered against filter fields in a specific way. If a filter field is not visible, only data related to its default member (a member of the corresponding hierarchy that is set as the default on the server) is processed. Otherwise, data is filtered according to the current filter condition.

For visible filter fields whose filter condition is set to 'Show All', you can change this behavior via the DefaultMemberFields property. To process only data related to these fields' default members, set the DefaultMemberFields property to PivotDefaultMemberFields.AllFilterFields.

To learn more, see OLAP Filtering Specifics.

See Also