PivotCellEventArgsBase<TField, TData, TCustomTotal>.RowValueType Property

Gets the type of row that contains the processed cell.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v24.2.Core.dll

Declaration

C#

public PivotGridValueType RowValueType { get; }

VB.NET

Public ReadOnly Property RowValueType As PivotGridValueType

Property Value

Type	Description
PivotGridValueType	A PivotGridValueType enumeration value that specifies the type of row in which the processed cell resides.

Available values:

Name	Description
Value	Corresponds to a field value.
Total	Corresponds to an automatic total.
GrandTotal	Corresponds to a grand total.
CustomTotal	Corresponds to a custom total.

Remarks

Use the RowValueType property to identify whether the processed cell resides within the grand total row, total row, etc.

Example

This example demonstrates how to handle the CustomCellValue event to hide field row totals and grand totals. The total values remain hidden when you expand or collapse field values.

View Example: Pivot Grid for WinForms - Hide Row Totals

Form1.cs

private void pivotGridControl1_CustomCellValue(object sender, PivotCellValueEventArgs e) {
    if (e.DataField == fieldLowLevel) {
        PivotGridField lastLevelField = 
            pivotGridControl1.GetFieldsByArea(PivotArea.RowArea).Last();
        if(e.RowValueType == PivotGridValueType.Total 
            || e.RowValueType == PivotGridValueType.GrandTotal 
            || e.RowField != lastLevelField)
            e.Value = null;
    } 
}

Form1.vb

Private Sub pivotGridControl1_CustomCellValue(ByVal sender As Object, ByVal e As PivotCellValueEventArgs) Handles pivotGridControl1.CustomCellValue
    If e.DataField Is fieldLowLevel Then
        Dim lastLevelField As PivotGridField = pivotGridControl1.GetFieldsByArea(PivotArea.RowArea).Last()
        If e.RowValueType = PivotGridValueType.Total OrElse e.RowValueType = PivotGridValueType.GrandTotal OrElse e.RowField IsNot lastLevelField Then
            e.Value = Nothing
        End If
    End If
End Sub