[Solved] Group aggregates - how to react to grouping changes

[Chris]

Hi,

 After a lot of searching I found out how to get group-level and grand-total aggregates working.  

 However, now that is in place, I find that changing the grouping via the GUI blows up.  

I guess this makes sense since the aggregation is set as a static object, but this must be a common requirement surely?  I want to have group level aggregates and the grand total continue to work even if the user wants different grouping.

 I've created a JSFiddle to focus any help people can offer.

I suspect this may involve my catching a grid event but I welcome any suggestion.  I can reference an object as the datasource group attribute.

var grouping = {
    field: "deal.dealStatus",
    aggregates: [{
        field: "valueUSD",
        aggregate: "sum"
    }]
};



    dealDataSource = new kendo.data.DataSource({
        ...
        aggregate: [
            { field: "valueUSD", aggregate: "sum" }
        ],
        //group: function () {
        //    return {
        //        field: "deal.dealStatus",
        //        aggregates: [{
        //            field: "valueUSD",
        //            aggregate: "sum"
        //        }]
        //    };
        //},
        group:grouping,

Is this the way to go?  To dynamically change "grouping" based on grouping changes?

 

 Thanks

Chris

 

[Chris]

Just as some extra info.  I see from making the below example "groupable: true" that I must be missing something.  This example seems to behave as I want. whatever grouping I set via the GUI.

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

[Rosen]

Hello Chris,

In order to change the groups dynamically and have aggregates, you will need to also declare the appropriate aggregate functions at the column aggregates configuration. This is shown in the online demo you have pointed.

Regards,
Rosen
Telerik