PivotGridControl.CollapseValue(Boolean, Object[]) Method

Collapses a specific column or row that is identified by the specified values.

Namespace : DevExpress.XtraPivotGrid

Assembly : DevExpress.XtraPivotGrid.v25.2.dll

NuGet Package : DevExpress.Win.PivotGrid

Declaration

csharp

public void CollapseValue(
    bool isColumn,
    object[] values
)

Public Sub CollapseValue(
    isColumn As Boolean,
    values As Object()
)

Name	Type	Description
isColumn	Boolean

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

| | values | Object[] |

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

To expand a column or row, use the PivotGridControl.ExpandValueAsync (asynchronous) or PivotGridControl.ExpandValue (synchronous) method.

Consider the following PivotGrid control:

To collapse the “Austria” column (within the “Alice Mutton” column), use the following code:

csharp

pivotGridControl1.CollapseValue(true, new object[] {"Alice Mutton", "Austria"});

pivotGridControl1.CollapseValue(True, New Object() {"Alice Mutton", "Austria"})

The result of this operation is shown below: