PivotCellBaseEventArgs.GetColumnGrandTotal(Object[], PivotGridField) Method

Returns a Column Grand Total value calculated for the specified row field values, against the specified data field.

Namespace : DevExpress.Xpf.PivotGrid

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

NuGet Package : DevExpress.Wpf.PivotGrid

Declaration

csharp

public object GetColumnGrandTotal(
    object[] rowValues,
    PivotGridField dataField
)

Public Function GetColumnGrandTotal(
    rowValues As Object(),
    dataField As PivotGridField
) As Object

Name	Type	Description
rowValues	Object[]

An array of row field values for which the required Column Grand Total is calculated.

| | dataField | PivotGridField |

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

Type	Description
Object

The Column Grand Total value calculated for the specified row field values, against the specified data field.

Consider the pivot grid displayed in the image below.

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

Cell	C#	Visual Basic
Red	`e.GetColumnGrandTotal(new object[] {1996, 2}, fieldProductSales);`	`e.GetColumnGrandTotal(New Object() {1996, 2}, fieldProductSales)`
Green	`e.GetColumnGrandTotal(new object[] {1996}, fieldProductSales);`	`e.GetColumnGrandTotal(New Object() {1996}, fieldProductSales)`
Blue	`e.GetColumnGrandTotal(null, fieldProductSales);`	`e.GetColumnGrandTotal(Nothing, fieldProductSales)`