Skip to main content

PivotGridControl.ExpandValue(Boolean, Object[]) Method

Expands the specified column or row.

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v22.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid


public void ExpandValue(
    bool isColumn,
    params object[] values


Name Type Description
isColumn Boolean

true to expand a column; false to expand a row.

values Object[]

An array of field values that identify the column/row to be expanded.


Consider the following PivotGridControl:


To expand ‘1995’ within “Aniseed Syrup”, do the following:

pivotGrid.ExpandValue(true, "Aniseed Syrup", 1995);

The image below shows the result:


To expand a column or row asynchronously, use the PivotGridControl.ExpandValueAsync method.

To collapse a column or row, use the PivotGridControl.CollapseValueAsync (asynchronous) or PivotGridControl.CollapseValue (synchronous) method.

See Also