<Grid>

  <Grid.Resources>

     <xcdg:DataGridCollectionViewSource x:Key="cvs_employees"

                                        Source="{Binding Source={x:Static Application.Current},

                                                         Path=Employees}">

       <xcdg:DataGridCollectionViewSource.DetailDescriptions>

          <xcdg:DataRelationDetailDescription RelationName="Employee_Orders"

                                              Title="Employee Orders">

             <xcdg:DataRelationDetailDescription.DetailDescriptions>

                <xcdg:DataRelationDetailDescription RelationName="Order_OrderDetails"

                                                    Title="Order Details">

                   <xcdg:DataRelationDetailDescription.ItemProperties>

                      <xcdg:DataGridItemProperty Name="UnitPrice" />

                      <xcdg:DataGridItemProperty Name="Quantity" />

                      <xcdg:DataGridItemProperty Name="Discount" />

                   </xcdg:DataRelationDetailDescription.ItemProperties>

                   <xcdg:DataRelationDetailDescription.StatFunctions>                         

                      <xcdg:SumFunction ResultPropertyName="sum_quantity"

                                        SourcePropertyName="Quantity" />

                      <xcdg:AverageFunction ResultPropertyName="average_unitprice"

                                            SourcePropertyName="UnitPrice" />

                   </xcdg:DataRelationDetailDescription.StatFunctions>

                </xcdg:DataRelationDetailDescription>

             </xcdg:DataRelationDetailDescription.DetailDescriptions>

          </xcdg:DataRelationDetailDescription>

       </xcdg:DataGridCollectionViewSource.DetailDescriptions>

     </xcdg:DataGridCollectionViewSource>

  </Grid.Resources>

 

  <xcdg:DataGridControl x:Name="EmployeesGrid"

                      ItemsSource="{Binding Source={StaticResource cvs_employees}}"

                      ItemsSourceName="Employee Information"

                      AutoCreateDetailConfigurations="True">

    <xcdg:DataGridControl.DetailConfigurations>

       <xcdg:DetailConfiguration RelationName="Employee_Orders">

          <xcdg:DetailConfiguration.DetailConfigurations>

             <xcdg:DetailConfiguration RelationName="Order_OrderDetails">

                <xcdg:DetailConfiguration.Footers>

                   <DataTemplate>

                      <xcdg:StatRow Background="AliceBlue">

                         <xcdg:StatCell FieldName="UnitPrice"

                                        ResultPropertyName="average_unitprice"

                                        ResultConverterParameter="f2" />

                         <xcdg:StatCell FieldName="Quantity"

                                        ResultPropertyName="sum_quantity" />                            

                      </xcdg:StatRow>

                   </DataTemplate>

                </xcdg:DetailConfiguration.Footers>

             </xcdg:DetailConfiguration>

          </xcdg:DetailConfiguration.DetailConfigurations>

       </xcdg:DetailConfiguration>

     </xcdg:DataGridControl.DetailConfigurations> 

   </xcdg:DataGridControl>

</Grid>