[Solved] GroupHeaderTemplate Show Aggregates For All Columns

[gregtayl]

Is it possible to display the aggregates for each column in the GroupHeaderTemplate (aligned with each column), similar to the way the GroupFooterTemplate works? I'd really like to display the totals when a group is collapsed.

[Petur Subev]

Hello Greg,

I am afraid that you cannot display the group aggregates header template when your Grid is grouped by some of the other columns.

All the best,
Petur Subev
the Telerik team

[gregtayl]

Hi Petur,

Thanks for the response.

Having the ability to specify the render location of the group templates would be a great feature. Two big complaints with displaying summaries in the GroupFooterTemplate are:

1. When data is grouped by multiple columns, the display becomes extremely confusing for users to read/understand. It's difficult to associate the summary row with the corresponding group. Providing the ability to render the summaries in-line with the group header (and aligned with each column) would greatly increase readability.
2. When a group is collapsed, the user is unable to view the summary information. When dealing with a large amount of data, we see great value in being able to compare group summaries. Without the ability to collapse a group AND still see the corresponding summary this becomes difficult and frustrating for users.

That being said, can you provide any suggestion to how we can display group summary rows when a group is collapsed?

Thanks,
Greg

[Petur Subev]

Hello Greg,

Since you are unable to use the aggregate values in the column group header template the only work-around I can think of, is to manually get and append the values to the header template:

1. Subscribe a function to the OnDataBound event
2. Get the calculated aggregate values and add them to the header. 

Here is an example how to get the Sum values of the unit price groups for our demo.

$($("#Grid").data('tGrid').dataSource._data).each(function () {
                //this is the group object for the most outer group
                console.log(this.aggregates.UnitPrice.Sum);
})

This is should give you the basic idea to create more complex logic to customize your Grid group headers.
I hope this helps.

All the best,
Petur Subev
the Telerik team