Start Building Professional
Web Apps Today

Extra Rows with calculated values inside of grid

Is there something similar to calculated columns for rows?

I have data that is going to be in this format:

C1 C2
A 1
A 2
A 3
A 4

B 2
B 4

C 5
C 2
C 3

I want to insert new row for each Unique Value of C1, so I would insert 3 new rows:
A 10
B 6
C 10

Where each value is the sum of all the values in C2 grouped by the key in C1. Is the best way of doing this to insert new rows right after the grid is loaded? Or is there something that has similar functionality?

You can do that with groupBy() functionality or with math operations in dhtmlxTreeGrid. Please find more information here
http://www.dhtmlx.com/docs/products/dhtmlxGrid/samples/07_extended_modes/02_pro_group_custom_format.html
http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxgrid:grouping&s[]=groupby&s[]=math#math_operations_in_group-by_mode
http://www.dhtmlx.com/docs/products/dhtmlxTreeGrid/samples/04_grid_operations/03_treeGrid_math.html
http://dhtmlx.com/dhxdocs/doku.php?id=dhtmlxtreegrid:math_formulas_in_treegrid