Totaling hierarchical data

[Drew]

I have a Grid on an aspx page that displays some hierarchical data.  I would like to total one column of the sub table and then subtract it from a column in its parent row and display the results in the sub table footer.  Is that possible, and if so, how do I go about it?

[Antonio Stoilkov]

Hello Drew,

You could achieve your scenario but it is not a trivial implementation. The required steps are described below:

• Enable Grid / Footer Aggregates functionality by following the demo and help article below
• http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/aggregates/defaultcs.aspx
• http://www.telerik.com/help/aspnet-ajax/grid-totals-in-footers.html

• Subscribe to RadGrid PreRender event

• Manually retrieve and calculate the result values and set the appropriate Text property of the column footer item. Note that you could go through the Accessing Cells and Rows in order to help you through the process of implementation and accessing items

All the best,
Antonio Stoilkov
the Telerik team