All docs
V20.1
20.1
19.2
The page you are viewing does not exist in version 19.2. This link will take you to the root page.
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.

FixedFieldValue Class

A column field value to be pinned.

Namespace: DevExpress.XtraPivotGrid

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

Declaration

public class FixedFieldValue :
    IXtraSupportDeserializeCollectionItem
Public Class FixedFieldValue
    Implements IXtraSupportDeserializeCollectionItem

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.

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

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

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

Inheritance

Object
FixedFieldValue
See Also