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.

Thanks in advance

#2

Hi,
sorry for the delay in answerring.
Unfortunately there is no way to do it.
Export script just takes data from grid/treegrid and renders it into excel, but it doesn’t support functions in header/footer.