Cannot see aggregates in grid

[Ewald]

I try to add aggregates to the grid. I see a row at the bottom of the grid, but there are no values.

JSFiddle: http://jsfiddle.net/ewaldhofman/49TxH/

What am I doing wrong?

[Alexander Popov]

Hello Ewald,

Since you are using grouped data I assume that you would like to display the group aggregates. In order to do so you have to:

1. Specify the group.aggregates option
2. Use the column.groupFooterTemplate to specify what to be shown in the footer

You can find an updated version of your example here.

Regards,
Alexander Popov
Telerik

[Ewald]

Thanks for your response.

You were right that I wanted to see the group totals, but in addition I would like to add the grand total as well. Is that possible?

I don't understand why you put the value "data.Facility.sum" in the groupFooterTemplate. In all the examples it is always just sum. And in the example I used local data, but in reality I use the remote data source (see below snippet). Does that make a difference?


                transport: {
                    read: options=> {
                        $.ajax({...}).done(result=> {
                                options.success(result);
                            }
                        );

[Alexander Popov]

Hello again Ewald,

Yes, displaying the total sum is possible. That would require adding a proper aggregate to the DataSource and using a footerTemplate, as shown in this updated example.
Using the "data.Facility.sum" reference yields the same result as just "sum" (unless useWithBlock is disabled), however the latter gives out more information on first glance, so which one you would use is a matter of personal preference. Regarding your last question - no, using remote data would not make any difference.

Regards,
Alexander Popov
Telerik

[Ewald]

Thanks for these detailed responses. I have been able to successfully implement it in my scenario.