PivotCustomDrawCellBaseEventArgs.GetRowGrandTotal(Object[], PivotGridField) Method

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

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.XtraPivotGrid.v24.1.dll

NuGet Package: DevExpress.Win.PivotGrid

Declaration

C#

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

VB.NET

Public Function GetRowGrandTotal(
    columnValues As Object(),
    dataField As PivotGridField
) As Object

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.

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[] {1995, 3}, fieldProductAmount);	e.GetRowGrandTotal(New Object() {1995, 3}, fieldProductAmount)
Green	e.GetRowGrandTotal(new object[] {1995}, fieldProductAmount);	e.GetRowGrandTotal(New Object() {1995}, fieldProductAmount)
Blue	e.GetRowGrandTotal(null, fieldProductAmount);	e.GetRowGrandTotal(Nothing, fieldProductAmount)

Note

If you call the GetRowGrandTotal method while an asynchronous operation is being performed, an exception will be thrown. To determine whether the operation is in progress, use the pivot grid’s IThreadSafeAccessible.IsAsyncInProgress property. For more information, see Asynchronous Mode.