Grouping rows without hierarchy

[Anders]

Hello,
I have a peculiar problem and I wonder how to best solve it.

We have data that is segmented in different levels. What I want to display is a list of all "top" levels with aggregated data for that level.
When the user expands/selects a row I want to query the database for the detail rows. The data has the exact same columns for all rows, so I don't want a nested view or table to screw up my alignements.

As an example: I have two regions, when I first look at the grid, I want to show the total number of products sold per region.
Then I select the southern region.
New rows are queried and inserted under the selection, showing for each outlet the specific number of the same products sold.
The same happens if I select the northern region.

I've attached four pictures to illustrate what I mean.

I tried getting it done using grouping, but the information per row is just a text, I would like it to display the same cells as the rows below.

Please advise how best to do this.

[Anders]

Well well well...

After perusing the samples and documentation i managed to implement something that will do the job, after some GUI fixing...

I followed what was described here:
self-referencing-hierarchy

Thanks all the same!