New to Telerik UI for ASP.NET MVC? Download free 30-day trial

Aggregates

The TreeList enables you to display aggregated number results when the user groups its data.

To enable the aggregate functions, use the DataSource.Aggregates() and the FooterTemplate() methods of the TreeList, and the aggregate fields of its data source.

    @(Html.Kendo().TreeList<Kendo.Mvc.Examples.Models.TreeList.EmployeeDirectoryModel>()
        .Name("treelist")
        .Columns(columns =>
        {
            columns.Add().Field(e => e.Extension).Title("Ext")
            .FooterTemplate("Tota: #= count #, Sum: #= sum #, Min: #= min #, Max: #= max #, Average: #= average #");
        })
        .DataSource(dataSource => dataSource
            .ServerOperation(false)
            .Read(read => read.Action("All", "EmployeeDirectory"))
            .Aggregates(aggr =>
            {
                aggr.Add(e => e.Extension).Count().Sum().Max().Min().Average();
            })
            .Model(m =>
            {
                m.Id(f => f.EmployeeId);
                m.ParentId(f => f.ReportsTo);
                m.Field(f => f.ReportsTo);
            })
        )
    )

For a runnable example, refer to the demo on using aggregate functions in the TreeList.

See Also

In this article