I have followed the info in http://www.telerik.com/community/forums/aspnet-ajax/grid/custom-aggregate-on-a-templated-column-with-grouping.aspx
it helps but doesn't get me quite where I need to be. I have a grid which I can declaratively group by at a couple of levels - bascially order lines within order reference within period. I have one column which is the currency equivalent for each line and this value is calculated in the ItemdataBound event.
I want either the Group Header or the Group Footer to show me the sum of this column and for the interim sums to also be shown - eg total value of each order reference at the innermost level and also total value of all orders in the period in the main group. Ideally if the user elects to drah and drop other groupings I would want the totals to be rolled up accordingly.
The sample code in teh forum msg above has two probs - one it seems to only work at the innermost level ie the outermost group header doesn't recursively sum everything below it. And two it seems to overwrite the group header text so any other useful text is lost to the label that is created in the code.
Is there any way to declaratively specify an aggregate on the template column?