Summary Type in JQuery PivotGrid widget
13 Feb 20191 minute to read
IMPORTANT
This feature is applicable only for the relational datasource at client mode.
Allow you to specify the required layout
that should be used in summary cells of the PivotGrid. “Sum” is the default summary type. Following are the supported summary types:
- Sum
- Average
- Count
- Min
- Max
$(function () {
$("#PivotGrid1").ejPivotGrid({
dataSource: {
data: pivotData,
//……
values: [{
fieldName: "Amount",
fieldCaption: "Amount",
summaryType: ej.PivotAnalysis.SummaryType.Average
},
{
fieldName: "Quantity",
fieldCaption: "Quantity",
summaryType: ej.PivotAnalysis.SummaryType.Sum
}
],
//……
},
});
});
