Skip to main content

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

[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.

image

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.

image

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