All docs
V21.1
21.2 (EAP/Beta)
21.1
20.2
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.

PivotGridControl.FixedColumnFieldValues Property

Provides access to the fixed columns collection.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v21.1.dll

Declaration

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

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.

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));
See Also