JavaScript/jQuery PivotGrid Summary Cell
An object exposing methods that manipulate a summary cell and provide access to its neighboring cells.
child(direction, fieldValue)
Use this method for Total and Grand Total cells to get one of the cells, whose value is involved in the calculation of the total value. The image below demonstrates what cell will be returned by the following code.
var targetCell = sourceCell.child("row", 8); //August is the 8th month
This method is opposite to the parent(direction) method.
children(direction)
This method is a general case of the child(direction, fieldValue) method. It returns all the cells whose values were involved in a calculation of the total value. Use it for Total and Grand Total cells.
field(area)
If the header items are expanded and the cell belongs to multiple fields, the field of the deepest expanded header item is returned. The image below demonstrates what field will be returned by the following code.
var columnField = sourceCell.field("column");
isPostProcessed(field)
Indicates whether the summaryDisplayMode or calculateSummaryValue post-processed the summary value.
next(direction)
This method is opposite of the prev(direction) method.
next(direction, allowCrossGroup)
This method is opposite of the prev(direction, allowCrossGroup) method.
parent(direction)
This method is opposite of the child(direction, fieldValue) method.
prev(direction)
This method is opposite of the next(direction) method.
prev(direction, allowCrossGroup)
This method is opposite to the next(direction, allowCrossGroup) method.
value(field, postProcessed)
Gets the value of any field associated with the summary cell.
Pass true to get a value post-processed by summaryDisplayMode or calculateSummaryValue; pass false to get the original summary value.
value(postProcessed)
Pass true to get a value post-processed by summaryDisplayMode or calculateSummaryValue; pass false to get the original summary value.
If you have technical questions, please create a support ticket in the DevExpress Support Center.