Hi

I need to get the total of all the rows in the data table. I tried the following demo trial

https://examples1.ext.net/#/GridPane...ping_TotalRow/

but i need to bind the data to the grid from the database.
I created a table as follows:

id group employees
-------------------------
1 aaa 21
1 aaa 32
1 aaa 26
2 abc 32
2 abc 12
2 abc 18
3 ccc 21
3 ccc 25
-------------------

I want the total as mentioned in the above link but i cannot able to read all the data with similar id.. that means im getting only the last value like this

id group employees
---------------------------
1 aaa 26
2 abc 18
3 ccc 25
------------------

What is the solution for that.....?????