Summary Type

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
                }
                ],
                //……
            },
        });
    });
    Caption to image