Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotCellBaseEventArgs.GetRowGrandTotal(Object[], PivotGridField) Method

Returns a Row Grand Total value calculated for the specified column field values, against the specified data field.

Namespace: DevExpress.Xpf.PivotGrid

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

NuGet Package: DevExpress.Wpf.PivotGrid

#Declaration

public object GetRowGrandTotal(
    object[] columnValues,
    PivotGridField dataField
)

#Parameters

Name Type Description
columnValues Object[]

An array of column field values for which the required Row Grand Total is calculated.

dataField PivotGridField

A PivotGridField object that specifies the data field, against which the required Row Grand Total is calculated.

#Returns

Type Description
Object

The Row Grand Total value calculated for the specified column field values, against the specified data field.

#Remarks

Consider the pivot grid displayed in the image below.

GetRowGrandTotal

The following table illustrates how to use the GetRowGrandTotal method to obtain specific grand total values.

Cell C# Visual Basic
Red e.GetRowGrandTotal(new object[] {1996, 1}, fieldProductAmount); e.GetRowGrandTotal(New Object() {1996, 1}, fieldProductAmount)
Green e.GetRowGrandTotal(new object[] {1996}, fieldProductAmount); e.GetRowGrandTotal(New Object() {1996}, fieldProductAmount)
Blue e.GetRowGrandTotal(null, fieldProductAmount); e.GetRowGrandTotal(Nothing, fieldProductAmount)
See Also