Adding a new Row wth dynamic values

[ashimmohanty]

I want to add a Row which would show the sum of all the values prior to it.
How can I do that ?Really dont know what to do....
Ex:

aaa	val1	val2
aaa	12	23
aaa	23	45
Total	35	68
bbb	10	16
bbb	16	10
Total	26	26

[ashimmohanty]

I want to render it from the server side only..I am getting the values of individual datas..i just want to render another row which would show their sum...

[narram123]

Hi,

When you get the response from server, loop thro the corresponding dataIndex and keep

adding the sum.Add a value to the store which contains the sum. It should work.

[sword-it]

Add load event listener to your store, so we can start process when store loads:

var store = new Ext.data.JsonStore({
.....
listeners: {
load: function(store, records, options){
var total = 0,
rowValue = 0,
totalRowRecord;

for(var i = 0, len = records.length; i < len; i++){
rowValue = parseInt(records[i].get('value'));
rowValue = !isNaN(rowValue) ? rowValue : 0;
if(((i + 1) % 5 === 0) || ((len % 5) > 0 && i === len - 1)){ //for each 5 records or for the last record show total row
total += rowValue;
totalRowRecord = new (store.reader.recordType)({ name: 'Total', value: total  });
store.insert(i, totalRowRecord); //insert total row
total = 0; //set 0 again
}
else {
total += rowValue;
}
}
}
}
});

This would probably work, give it a try!

Regards.