Aggregates based on child group aggregates

[jmillar]

Hi all;

I'm struggling with the best way to approach this one.  I have a requirement for a grid with two levels grouping (outer and inner).  The inner group requires aggregates of the average of the detail lines in the group - no problem there.  The outer group, though, needs the average of the inner group results -- NOT the average of all the child detail lines.  Anybody have any suggestions how I should approach this?

Thanks,

Jason

[Eyup]

Hello Jason,

I am afraid this requirement is not supported out of the box. RadGrid provides custom aggregate possibility, but again it is based on per record logic:
http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/columns/aggregates

Generally, if paging is not enabled, you can traverse the child group headers and access their sub-aggregates, although this is very specific scenario and beyond our support scope:
http://www.telerik.com/forums/custom-aggregate-on-a-templated-column-with-grouping

Regards,
Eyup
Telerik