I currently have a function grid similar to:
So the grid would show results like:
What I now want to do is add another footer row so that the grid would look like:
Is it possible to add a 2nd footer row and if so how can I accomplish that?
<telerik:RadGridView Grid.Row="2" Grid.ColumnSpan="2" x:Name="MyGridView"
ItemsSource="{Binding MyItems}"
RowIndicatorVisibility="Collapsed"
ShowColumnFooters="True"
ShowGroupPanel="False"
IsReadOnly="True"
HorizontalContentAlignment="Stretch"
VerticalAlignment="Top">
<telerik:RadGridView.Columns>
<telerik:GridViewDataColumn DataMemberBinding="{Binding MonthDisplay}" Header="Month" Width="65">
<telerik:GridViewDataColumn.Footer>
<TextBlock Text="Totals:"/>
</telerik:GridViewDataColumn.Footer>
</telerik:GridViewDataColumn>
<telerik:GridViewDataColumn DataMemberBinding="{Binding Column1Data}" Header="Column 1" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
<telerik:GridViewDataColumn.AggregateFunctions>
<telerik:SumFunction/>
</telerik:GridViewDataColumn.AggregateFunctions>
</telerik:GridViewDataColumn>
<telerik:GridViewDataColumn DataMemberBinding="{Binding Column2Data}" Header="Column 2" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
<telerik:GridViewDataColumn.AggregateFunctions>
<telerik:SumFunction/>
</telerik:GridViewDataColumn.AggregateFunctions>
</telerik:GridViewDataColumn>
<telerik:GridViewDataColumn DataMemberBinding="{Binding Column3Data}" Header="Column 3" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
<telerik:GridViewDataColumn.AggregateFunctions>
<telerik:SumFunction/>
</telerik:GridViewDataColumn.AggregateFunctions>
</telerik:GridViewDataColumn>
<telerik:GridViewDataColumn DataMemberBinding="{Binding Column4Data}" Header="Column 4" Width="*" MinWidth="40" MaxWidth="95" DataFormatString="#,###0.##" TextAlignment="Right" FooterTextAlignment="Right">
<telerik:GridViewDataColumn.AggregateFunctions>
<telerik:SumFunction/>
</telerik:GridViewDataColumn.AggregateFunctions>
</telerik:GridViewDataColumn>
</telerik:RadGridView.Columns>
</telerik:RadGridView>
So the grid would show results like:
Month Column1 Column2 Column3 Column4 Jan 1 2 3 4 Feb 1 2 3 4 March 1 2 3 4 Totals: 3 6 9 12
What I now want to do is add another footer row so that the grid would look like:
Month Column1 Column2 Column3 Column4 Jan 1 2 3 4 Feb 1 2 3 4 March 1 2 3 4 Totals: 3 6 9 12 Average:1 2 3 4