Help with grouping

[Zack]

Hello I'm looking for a way to group my data, and would like to know if it is possible to do.

It is possible for one record to exist multiple groups, and I would like to display this somehow.

Ex: Records:

AccountId - DimensionId - DimValue

Account1 - Dimension1 - 000
Account1 - Dimension2 - 213
Account1 - Dimension3 - 390

Account2 - Dimension1 - 000
Account2 - Dimension2 - 240
Account2 - Dimension3 - 300

Account3 - Dimension1 - 000
Account3 - Dimension2 - 240
Account3 - Dimension3 - 290

Account4 - Dimension1 - 000
Account4 - Dimension2 - 240
Account4 - Dimension3 - 610

Account5 - Dimension1 - 000
Account5 - Dimension2 - 240
Account5 - Dimension3 - 610

I want my report to display something like this:

000
213
390
Account1
390
213

240
300
Account2
300

590
Account3
590

610
Account4
Account5
610
240
000

Is this possible

[Elian]

Hello Zack,

This seems doable. You can  group by dimensions. 
Sample group hierarchy:

Group1 - Dimension1
Group2 - Dimension2 (child to 1)
Group3 - Dimension3 (child to 2)

and you will have the Dimensions value in both the GroupHeader and GroupFooter section to have the desired layout. 
 
Regards,
Elian
Telerik