How to group in Detail Section of Telerik Reporting?

[Afnan]

I have one group header section and detail section like this :



    Name1 Name2 Name3 Name4 Name5// Group Header Section
    
    GroupBy // Group Header Section
    
     a      2    3     2       9 -|
     a      4    3     3       4 -|    // Detail Section
     a      6    2     4       3 -|
     a      7    1     5       3 -|

These four rows is being produced by GroupBy criteria. So far it is working. 
Now I want to make one row of these four rows as Name1 is identical and other columns will be average like in Name2 average would be like `2+4+6+7/4` and same for other columns and one row will look like 

`a 4.75 2.25 3.5 4.75 `

[Nasko]

Hello Afnan,

You need to group by the Name1 data field and then in the newly added Group Header or Group Footer section add text boxes for the other data fields wrapped in the Avg() aggregate function.

For more information, please refer to the Grouping Data help articles.

Regards,
Nasko
Telerik