How to: Hide Row Totals

• Mar 06, 2019

This example demonstrates how to use the CustomCellValue event to hide field’s row totals and grand totals. When field values are collapsed, the totals remain hidden.

Note

The complete sample project How to Handle the CustomValueCell Event to Hide Row Totals is available in the DevExpress Examples repository.

C#

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;
    } 
}

VB.NET

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