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.v24.2.dll
NuGet Package: DevExpress.Wpf.PivotGrid
Declaration
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 for the specified row 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 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) |