All-rows aggregate in server side grid

Hello there,

public IActionResult UrlDatasource(DataManagerRequest dm)          {                IEnumerable DataSource = order;              DataOperations operation = new DataOperations();    . . .              List<string> str = new List<string>();              if (dm.Aggregates != null)              {                  for (var i = 0; i < dm.Aggregates.Count; i++)                      str.Add(dm.Aggregates[i].Field);              }              IEnumerable aggregate = operation.PerformSelect(DataSource, str);              int count = DataSource.Cast<Orders>().Count();              if (dm.Skip != 0)              {                  DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging              }              if (dm.Take != 0)              {                  DataSource = operation.PerformTake(DataSource, dm.Take);              }              return dm.RequiresCounts ? Json(new { result = DataSource, count = count, aggregate = aggregate }) : Json(DataSource);          }

Hi Prasanna,
Attachment: grid_68feb500.zip

public IActionResult UrlDatasource(DataManagerRequest dm)          {                IEnumerable DataSource = order;              DataOperations operation = new DataOperations();    . . .              List<string> str = new List<string>();              if (dm.Aggregates != null)              {                  for (var i = 0; i < dm.Aggregates.Count; i++)                      str.Add(dm.Aggregates[i].Field);              }              IEnumerable aggregate = operation.PerformSelect(DataSource, str);              int count = DataSource.Cast<Orders>().Count();              if (dm.Skip != 0)              {                  DataSource = operation.PerformSkip(DataSource, dm.Skip);   //Paging              }              if (dm.Take != 0)              {                  DataSource = operation.PerformTake(DataSource, dm.Take);              }              return dm.RequiresCounts ? Json(new { result = DataSource, count = count, aggregate = aggregate }) : Json(DataSource);          }

Hi there,

You've just repeated the code you sent before!
I have successfully added aggregate from server, my problem is that the aggregate does not change when grid's data is updated. 
For example when I do a search or filter data, I receive grid's data again from server and update grid according to the updated data. But the aggregate won't be updated.
How can I update the aggregate every time I update grid's data?

[Vue]  <template>    <div class="col-lg-12 control-section">      <div>        <ejs-grid :dataSource="data" ref="grid" :load="load" :allowPaging="true">          <e-columns>  . . .                <e-column type="Custom" field="Freight" format="C2" :customAggregate="customAggregateFn"  :footerTemplate="sumTemplate"></e-column>              </e-columns>            </e-aggregate>          </e-aggregates>        </ejs-grid>      </div>    </div>  </template>  <script>  import Vue from "vue";  import {    GridPlugin,    Sort,    Group,    Page,    Toolbar,    Aggregate  } from "@syncfusion/ej2-vue-grids";  import { DataManager, WebApiAdaptor,DataUtil } from "@syncfusion/ej2-data";    Vue.use(GridPlugin);  class extendedApiAdaptor extends WebApiAdaptor {      processResponse(          data, ds, query, xhr, request, changes) {          var original = super.processResponse.apply(this, arguments);              var aggregateData = data.Aggregate;              return DataUtil.isNull(original.count) ? original.result : { result: original.result, count: original.count, aggregates: aggregateData };      }  }  export default Vue.extend({    data() {      return {        data: new DataManager({          url: "api/Orders",          adaptor: new extendedApiAdaptor(),          crossDomain: true        }),        sumTemplate: function() {          return {            template: Vue.component("sumTemplate", {              template: `<span>Custom: {{data.Custom}}</span>`,              data: function() {                return { data: { data: {} } };              }            })          };        }      };    },    methods: {      load : function (e) {         var aggregatesField = ['Freight']  this.$refs.grid.ej2Instances.dataSource.dataSource.headers = [];  // add the required aggregates value to the header  this.$refs.grid.ej2Instances.dataSource.dataSource.headers.push({ aggregates: JSON.stringify(aggregatesField) });       },           customAggregateFn : function (data) {            console.log(data.aggregates);  // here you will get all the data for the aggregate   field and calculate your own aggregation             return  calculated value        }    },    provide: {      grid: [Sort, Group, Aggregate, Page, Toolbar]    }  });  </script>  <style>  @import "https://cdn.syncfusion.com/ej2/material.css";  </style>

[Controller side]     public class OrderController : ApiController      {          // GET: api/Order          public object Get()          {                            var queryString = System.Web.HttpContext.Current.Request.QueryString;             // get the values passed through request header              string agg = Request.Headers.GetValues("aggregates").ToList()[0];              DataOperations ds = new DataOperations();              object aggregate = null;              var data = OrdersDetails.GetAllRecords();              if (agg != null)              {                    List<string> aggregates = (List<string>)JsonConvert.DeserializeObject(agg, typeof(List<string>));                  aggregate = ds.PerformSelect(data, aggregates);              }               . . .             }              return new              {             //return the Aggregates along with result and count                  Items = data.Skip(skip).Take(take),                  Count = data.Count(),                  Aggregate = aggregate                   };          }