Skip to main content

PivotGridCellTemplateItem.GetColumnGrandTotal(Object[], PivotGridField) Method

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

Namespace: DevExpress.Web.ASPxPivotGrid

Assembly: DevExpress.Web.ASPxPivotGrid.v24.2.dll

NuGet Package: DevExpress.Web

#Declaration

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

#Parameters

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.

#Returns

Type Description
Object

The column grand total value calculated against the specified data field and from the specified row values.

#Remarks

Consider the pivot grid displayed in the image below.

GetColumnGrandTotal

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

Cell C# Visual Basic
Green cellTemplateItem.GetColumnGrandTotal(new object[] {1, "Condiments"}, fieldOrderAmount); cellTemplateItem.GetColumnGrandTotal(New Object() {1, "Condiments"}, fieldOrderAmount)
Blue cellTemplateItem.GetColumnGrandTotal(new object[] {1}, fieldOrderAmount); cellTemplateItem.GetColumnGrandTotal(New Object() {1}, fieldOrderAmount)
Red cellTemplateItem.GetColumnGrandTotal(null, fieldOrderAmount); cellTemplateItem.GetColumnGrandTotal(Nothing, fieldOrderAmount)
See Also