FixedFieldValue Class

Namespace : DevExpress.XtraPivotGrid

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

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

Declaration

C#
VB.NET

csharp

public class FixedFieldValue :
    IXtraSupportDeserializeCollectionItem,
    IFixedFieldValue

Public Class FixedFieldValue
    Implements IXtraSupportDeserializeCollectionItem,
               IFixedFieldValue

Remarks

To pin a column, follow the steps below:

Create a FixedFieldValue object.
Assign a DataField to the FixedFieldValue.DataField property. If the Pivot Grid control displays multiple data fields, pick a field whose values should be pinned.
Create a FixedFieldValueCondition and specify a column area field and its value. This information, together with the data field, indicates the column that should be pinned.
Add the created condition to the Conditions collection.
Add the created FixedFieldValue object to the PivotGridControl.FixedColumnFieldValues collection.

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

C#
VB.NET

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);
}

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#
VB.NET

csharp

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

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

Implements

IXtraSupportDeserializeCollectionItem

Inheritance

Object FixedFieldValue