title: How To Calculate Sum of jqgrid columns on footer row Locally
body: <p>After Displaying my database into jqgrid i need to add summary footer row which needs to calculate the sum of the particular column.I am populating Jqgrid locally..Also I have added Jqgrid Filter Which filters the data .According to my need I want my Summary footer to get changed on filtering the data from jqgrid filter toolbar...</p>
  
  <p>Here is my code:</p>
  
  <pre><code>$(function () {
  var gridData = null;
  var nn = null;
  $.ajax({
      url: 'Default.aspx/MyMethod',
      dataType: 'json',
      contentType: "application/json; charset=utf-8",
      type: 'POST',
      success: function (ReportDataNew, textStatus, XMLHttpRequest) {
          gridData = JSON.parse(ReportDataNew.d);
          console.log(gridData);
  
          $("#gridId").jqGrid({
              data: gridData,
              datatype: "local",
              height: '100%',
              autowidth: true,
              ignoreCase: true,
              rowNum: 100,
              rowList: [100, 200, 300],
              colNames: ['UserName', 'Ordinal', 'Extension', 'Trunk', 'Dialnumber', 'DialDate', 'DialTime', 'Duration', 'Destination', 'Price'],
              colModel: [
                         { name: 'username', index: 'username', width: 100, sortable: true, align: 'center' },
                         { name: 'ordinal', index: 'ordinal', width: 100, sortable: true, align: 'center' },
                         { name: 'price', index: 'price', width: 100, sortable: true, align: 'center'}
                        ]
  </code></pre>
  
  <p>I need to calculate the sum of <code>price</code> column</p>