[DEVEXPRESS/WPF] PivotGridControl 클래스 : 그룹 필터 적용하기

▶ XAML

<dxpg:PivotGridControl x:Name="pivotGridControl"
    BestFitMode="AllRows">
    <dxpg:PivotGridControl.Fields>
        <dxpg:PivotGridField
            FieldName="Extended Price"
            Area="DataArea"
            CellFormat="c0" />
        <dxpg:PivotGridField
            FieldName="CategoryName"
            Area="RowArea" 
            Caption="Product Category" />
        <dxpg:PivotGridField
            FieldName="OrderDate"
            Area="ColumnArea" 
            GroupInterval="DateYear"
            Caption="Year" />
        <dxpg:PivotGridField
            FieldName="OrderDate"
            Area="ColumnArea" 
            GroupInterval="DateMonth"
            Caption="Month" />
    </dxpg:PivotGridControl.Fields>
</dxpg:PivotGridControl>

 

728x90

 

▶ C#

using DevExpress.Xpf.PivotGrid;

...

PivotGridGroup pivotGridGroup = this.pivotGridControl.Groups.Add
(
    this.pivotGridControl.Fields[2],
    this.pivotGridControl.Fields[3]
);

pivotGridGroup.FilterValues.BeginUpdate();

pivotGridGroup.FilterValues.FilterType = FieldFilterType.Included;

pivotGridGroup.FilterValues.Values.Add(1994);

pivotGridGroup.FilterValues.Values.Add(1995).ChildValues.Add(1);

pivotGridGroup.FilterValues.EndUpdate();