Need to have excel like Fx filteration

Suite and Optimus Suite 5
#1

In tree grid can we use the filter like excel do, for any column we need to see the count, sum, avg etc for groups or user. Like the example in attached screen.so selecting the count will show the count related to that particuler group and other will work accordinglly.

Example:
Class(Group) (Count=3;Sum=90;Avg=30)
------ Student 1 (20)
------ Student 2 (30)
------ Student 3 (40)

So in column if i select filter as count it should show 3 front of the Class group, if i select Sum it should show the 90 etc.

Filter selection need to work according to the attached image.

Thanks in advance

#2

You may create your own custom filter with any needed logic.
Here you can find a tutorial about the filtration in the grid:
docs.dhtmlx.com/doku.php?id=dhtmlxgrid:filtering