Back to Devexpress

FixedFieldValue.Conditions Property

corelibraries-devexpress-dot-xtrapivotgrid-dot-fixedfieldvalue-6e078a0e.md

latest2.6 KB
Original Source

FixedFieldValue.Conditions Property

Specifies field values that should be pinned.

Namespace : DevExpress.XtraPivotGrid

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

NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

csharp
public FixedFieldValueConditionCollection Conditions { get; }
vb
Public ReadOnly Property Conditions As FixedFieldValueConditionCollection

Property Value

TypeDescription
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.

csharp
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
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.

csharp
pivotGridControl1.FixedColumnFieldValues.Add(new FixedFieldValue(fieldQuantity));
vb
pivotGridControl1.FixedColumnFieldValues.Add(New FixedFieldValue(fieldQuantity))

See Also

FixedFieldValue Class

FixedFieldValue Members

DevExpress.XtraPivotGrid Namespace