FixedFieldValue.Conditions Property

Specifies field values that should be pinned.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.WindowsDesktop.PivotGrid.Core

Declaration

C#

public FixedFieldValueConditionCollection Conditions { get; }

VB.NET

Public ReadOnly Property Conditions As FixedFieldValueConditionCollection

Property Value

Type	Description
FixedFieldValueConditionCollection	A FixedFieldValueConditionCollection object that specifies field values.

Remarks

The code snippet below illustrates how to pin the fieldQuantity field values that belong to the February 2015 interval.

C#

using DevExpress.XtraPivotGrid;

//...

public Form1() {
var info = new FixedFieldValue(fieldQuantity);
info.Conditions.Add(
    new FixedFieldValueCondition(fieldYear, new DateTime(2015, 2, 1)));
pivotGridControl1.FixedColumnFieldValues.Add(info);
}

VB.NET

Imports DevExpress.XtraPivotGrid

'...

Public Sub New()
Dim info = New FixedFieldValue(fieldQuantity)
info.Conditions.Add(New FixedFieldValueCondition(fieldYear, New DateTime(2015, 2, 1)))
pivotGridControl1.FixedColumnFieldValues.Add(info)
End Sub

If you specify no conditions, the “Grand Total” column is pinned.

C#

pivotGridControl1.FixedColumnFieldValues.Add(new FixedFieldValue(fieldQuantity));

VB.NET

pivotGridControl1.FixedColumnFieldValues.Add(New FixedFieldValue(fieldQuantity))