Summary type

11 Feb 20191 minute to read


This feature is applicable only for the relational data source only at client mode.

Allows you to specify the required summary type to be used in the summary cells of the pivot grid. The sum is the default summary type. Following are the summary types that are supported:

  • Sum
  • Average
  • Count
  • Min
  • Max
  • HTML
  • <ej:PivotGrid ID="PivotGrid1" runat="server" ClientIDMode="Static">
                <ej:Field FieldName="Country" FieldCaption="Country"></ej:Field>
                <ej:Field FieldName="Product" FieldCaption="Product"></ej:Field>
                <ej:Field FieldName="Amount" FieldCaption="Amount" SummaryType="Average"></ej:Field>
                <ej:Field FieldName="Quantity" FieldCaption="Quantity" SummaryType="Sum"></ej:Field>
        <ClientSideEvents Load="onLoad" />
    <script type="text/javascript">
            function onLoad(args) {
       = pivot_dataset; // Datasource

    Summary types in ASP NET pivot grid control