PivotGridControl.GetCellValue(Object[], Object[], PivotGridField) Method
Returns a cell value calculated for the specified column and row field values, against the specified data field.
Namespace: DevExpress.XtraPivotGrid
Assembly: DevExpress.XtraPivotGrid.v24.1.dll
NuGet Package: DevExpress.Win.PivotGrid
Declaration
public object GetCellValue(
object[] columnValues,
object[] rowValues,
PivotGridField dataField
)
Parameters
Name | Type | Description |
---|---|---|
columnValues | Object[] | An array of column field values that identify the column where the cell resides. |
rowValues | Object[] | An array of row field values that identify the column where the cell resides. |
dataField | PivotGridField | A PivotGridField object that specifies the data field, against which the required cell value is calculated. |
Returns
Type | Description |
---|---|
Object | A summary value calculated for the specified column and 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 GetCellValue method to obtain specific cell values.
Cell | C# | Visual Basic |
---|---|---|
Red | pivotGridControl.GetCellValue(new object[] {1995, 3}, new object[] {"Alice Mutton"}, fieldProductAmount); |
pivotGridControl.GetCellValue(New Object() {1995, 3}, New Object() {"Alice Mutton"}, fieldProductAmount) |
Green | pivotGridControl.GetCellValue(new object[] {1995}, new object[] {"Aniseed Syrup"}, fieldProductAmount); |
pivotGridControl.GetCellValue(New Object() {1995}, New Object() {"Aniseed Syrup"}, fieldProductAmount) |
Blue | pivotGridControl.GetCellValue(null, new object[] {"Boston Crab Meat"}, fieldProductAmount); |
pivotGridControl.GetCellValue(Nothing, New Object() {"Boston Crab Meat"}, fieldProductAmount) |