RealGrid2 Guide
Tip 🆕
Calculate the sum of merged cells

Calculate the sum of merged cells

Just calculate the sum of the merged cells in the footer's valueCallback and return it.

Loading RealGrid...
var columns = [
   ...skip...
   {
     name: "Age",
     fieldName: "Age",
     width: 50,
     mergeRule: "value",
     header: {
       text: "Age",
       styleName: "orange-column"
     },
     numberFormat: "#,##0",
     footer: {
       valueCallback: function(grid, column, footerIndex, columnFooter, value){
         var sum = 0;
         var i = 0;
         var iCnt = grid.getItemCount();
    
         while(i < iCnt) {
             var items = grid.getMergedItems(i, column.name);
             sum += grid.getValue(items[0], column.name);
             i += items.length;
         }
    
         return sum;
       },
       numberFormat: "#,##0",
       styleName: "center-column"
     }
   },
   ...skip...
];