Kendo Grid Multilevel grouping with different aggregates

[Paul]

Hi, 

I've got a Datagrid grouped by two different groups.The footer templates seems to be working just for the first group. Is it possible to define the footerTemplate for more than one group.

 

This is the datasource:

 

dataSource: {
                    group:[
                        {field: "style", dir: "desc",
                            aggregates: [
                                    { field: "style", aggregate: "count" },
                                    { field: "fob", aggregate: "sum" },
                                    { field: "quantity", aggregate: "sum" },
                                    { field: "approvedQuantity", aggregate: "sum" },
                                    { field: "sellingTotal", aggregate: "sum" },
                                    { field: "fobTotal", aggregate: "sum" },
                            ],
                        },
                        {
                            field: "colour", dir: "desc",
                            aggregates: [
                                    { field: "style", aggregate: "count" },
                                    { field: "fob", aggregate: "sum" },
                                    { field: "quantity", aggregate: "sum" },
                                    { field: "approvedQuantity", aggregate: "sum" },
                                    { field: "sellingTotal", aggregate: "sum" },
                                    { field: "fobTotal", aggregate: "sum" },
                            ],
                        }
                    ],

 

And this is the column:

 

{
                            field: "colour",
                            title: "Colour",
                            footerTemplate: function (data) {
                               
                                return "<div style='text-align:right'>Total Buy Margin: 100%</div>"
                            },
                            groupFooterTemplate: function (data) {
                               
                                var groupBuyMargin = 98; // This is just an example

                                return "<div style='text-align:right'>Style Buy Margin: " + groupBuyMargin + "%</div>"
                            },
                        }

 

Thanks,

Paul

[Konstantin Dikov]

Hello Paul,

The footerTemplate is not linked with the grouping and it is rendered for the entire Grid only once. In other hand, the groupFooterTemplate is rendered for each group. Detailed information and examples for the "footerTemplate" and the "groupFooterTemplate" could be found in the following help topics:

• https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.footertemplate 
• https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.groupfootertemplate

Note that each column could have only one footerTemplate and one groupFooterTemplate and they are used in each group level. 

Regards,
Konstantin Dikov
Progress Telerik