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 `
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 `