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

js

$(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
            }
            ],
            //……
        },
    });
});