Multiple conditional subtotol results by Group

[Tim]

Hello using the RadGrid control, trying to have multiple subtotal results group (conditional totals) appear in either the Group Header or Footer Preferred. I can only seem to do one total per group per column using ,<GroupByExpressions>. Given a simple dataset of
Group Color Value
1    Red    5
1    Red    2
1    Blue   3
2    Red    4
2    Green 4
2    Green 5

I would like the Grid to Output with the following "Conditional" subtotals in the Group Footer(ideal) or Header and can the RadGrid display Group Totals with more than 1 line, all examples show just output on a single line?

Group Color Value
1    Red    5
1    Red    2
1    Blue   3
-----
Group 1 Color: Red Count: 2 Value 7
Group 1 Color: Blue Count:1 Value 3
-----
2    Red    4
2    Green 4
2    Green 5
----
Group 2 Color: Red Count: 1 Value 4
Group 2 Color: Green Count: 2 Value 9
----

Possible with RadGrid??
Tim

[Mira]

Hello Tim,

In order to implement the desired functionality, I recommend that you group the grid by Group and by Color at the same time.
Please examine the following resources for additional information:
Declarative definition
Group Footers demo
Group Footers help topic

I hope this helps.

Regards,
Mira
the Telerik team