Aggregates totals with multiple levels of grouping

[Michael]

Hi,

I'm having a minor issue with showing aggregate totals when using 2 levels of grouping on a Grid. My grid is grouped by Vendor then invoice and the totals show once for each level of grouping. This is what I want but when there is only one invoice in the group it looks quite confusing (please see attached). Is there a way in the ClientGroupFooterTemplate to check which level of grouping is currently being shown so I can change the labelling accordingly? So something like the below but I don't know how I would calculate the function IAmInvoiceTotal().

.ClientGroupFooterTemplate("# if(IAmAnInvoiceTotal()){#Invoice Total : #= kendo.toString(sum, 'c') #}else{#Vendor Total : #= kendo.toString(sum, 'c') #}");

I can use jquery to check the class of the previous row and work out which level of grouping I'm at and dynamically change the label that way but it seems like there is probably an easier way.

[Alexander Popov]

Hello Michael,

I would recommend adding a "count" aggregate as well and the check its value in the template. This will allow you to identify the number of items in a group and show the sum accordingly.

Regards,
Alexander Popov
Telerik

 

 

[Haluk]

Please can you help me for this situation 

http://www.telerik.com/forums/telerik-mvc-grid-row-values-failing-after-group-by