PivotCellEventArgsBase<TField, TData, TCustomTotal>.RowField Property

Gets the innermost row field that corresponds to the processed cell.

Namespace: DevExpress.XtraPivotGrid

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

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

public TField RowField { get; }

VB.NET

Public ReadOnly Property RowField As TField

Property Value

Type	Description
TField	A T object that is the row field.

Remarks

If the processed cell resides within a Row Grand Total, the RowField property returns null. Otherwise, this property returns the innermost row field that corresponds to the processed cell.

Use the e.GetFieldValue method to get any field’s value for the processed cell.

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