I have a grid where the group header of a group should be based on values in other columns.
The last column represents the percent value of (third column/first column) .
The group header of the last column should also give the result of this sum.
So in this case the group header of the last column should be 1/3 = 33,33.
With the existing aggregates I don’t have the posibility to achieve this result, and I don’t want to override the existing group headers with a customgroupformat.
Is there a function avaiable to write a custom aggregate which is based on the column values?
Par example like this:
return (grid.cells(id,1).getValue() / grid.cells(id,3).getValue()) * 100;