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.

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...
];