Can I have a summary row stay at the first row of the grid?

[Jerry]

I am new to kendo UI, need your help, please -

I am trying to use kendogrid to create a table. Please see the attached image as an example.  

I have a special requirement - need a summary row always keeps in the first row regardless how the table is sorted. So my questions are:
1. Can I insert a summary row (data is in different format comparing to other rows) into the table?
2. How to keep the summary row always in the first place of the table?
3. The data I loaded from server via Ajax call in the following format, how to split it for the Summary row and the regular row.  
{  
    {"Summary":{"working order": 5, "completed order": 15}},
    {"Details":
     ["User Name": "Jerry", "working order":2,  "Completed order": 10],
     ["User Name": "Peter", "working order":3,  "Completed order": 6]}
}  
** the summary is not sum of the columns. 

If kendogrid doesn't support it, any suggestion for a workaround? 

Thanks,
Jerry

[Petur Subev]

Hello Jerry,

Our implementation of the summary row that you shared is actually our footer template. Sadly the position can only be at the bottom and if you want to provide the values shown on this row you need to override the templates by invoking external functions.

http://demos.telerik.com/kendo-ui/grid/aggregates


How to invoke external function from the footerTemplate is covered here (the example is for column template but the approach remains the same).

Kind Regards,
Petur Subev
Telerik

 

 

[Jerry]

Thank you Petur for your reply. It helps :-)