[Solved] How do I create a grid like this?

[Aaron]

I need to create a grid like the one in the attached image.  I think that the Grid control is the appropriate control but I'm not sure how to make to it look like the mock up. I need to match the look of the mock up as closely as possible.

I think using column grouping will be how I can make the columns have subcolumns (as indicated by the red box in the attached image).

I'm not certain but I think that a NestedViewTemplate is what is needed to create groups of rows (as indicated by the green box in the attached image). My only concern is that the resulting grid needs to show all of the data. The expand/collapse functionality is not desired.

Also, footer rows with grand totals need to be displayed for each of the groups in the NestedViewTemplate (as indicated by the cyan box in the attached image).

Is the grid control the right tool for the job? Am I on the right path in trying to use the grid as I've described above to match the grid in the attached image?

Thanks!

[Princy]

Hi Aaron,

You may try the RadPivotGrid to achieve your required scenario. Please take a look at the online demo on RadPivotGrid.

Thanks,
Princy

[Aaron]

Wow! That is exactly what I'm looking for. Thanks!