PivotGridControl.FixedColumnFieldValues Property

Provides access to the fixed columns collection.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v22.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

[Browsable(false)]
[XtraSerializableProperty(XtraSerializationVisibility.Collection, true, false, true, 0, XtraSerializationFlags.CollectionContent)]
public FixedFieldValueCollection FixedColumnFieldValues { get; }

VB.NET

<Browsable(False)>
<XtraSerializableProperty(XtraSerializationVisibility.Collection, True, False, True, 0, XtraSerializationFlags.CollectionContent)>
Public ReadOnly Property FixedColumnFieldValues As FixedFieldValueCollection

Property Value

Type	Description
FixedFieldValueCollection	A FixedFieldValueCollection object that is a collection of fixed 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))