FixedFieldValue Class

A column field value to be pinned.

Namespace: DevExpress.XtraPivotGrid

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

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

Declaration

C#

public class FixedFieldValue :
    IXtraSupportDeserializeCollectionItem

VB.NET

Public Class FixedFieldValue
    Implements IXtraSupportDeserializeCollectionItem

Related API Members

The following members return FixedFieldValue objects:

• PivotFieldValueItem.FixedValue

Remarks

To pin a column, follow the steps below:

1. Create a FixedFieldValue object.
2. 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.
3. 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.
4. Add the created condition to the Conditions collection.
5. 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#

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

Implements

IXtraSupportDeserializeCollectionItem

Inheritance

Object

FixedFieldValue