Create table with selections from different levels in a cyclic

[#1]

Hi,

How is the posibilty to create a table with information from different levels in the same table.

i have the following information in a cyclic:

level 1          Branch1                Group1

                                                  Group2

                                                   Group3

                   Branch2                 Group4 

                                                  Group5

                                                   Group6

level 2          Branch4                Group7

                                                  Group8

                                                   Group9

                   Branch5                 Group10 

                                                  Group11

                                                   Group12

I would like to create a tabe view and chart that show:

Level1

Branch2

Branch 4

Group 3

Group 11

So what we are woundering about to be clear is the experssions

Thanks in advance!

Best regards

Dag-Erik Eriksen

[#2]

I'd also really like an answer to this question!

I'm working on making a chart and a table including 4 different fields. The problem is that two of the fields I need are from the highest level in the cyclic, one field is from the second level and the last field contains information from the third and fourth level in the cyclic.

When I'm using set analysis to choose some information from one level, other information from the other levels that I need is excluded.

So, basically the same question as above.

Anyone who is able to help with this problem??

Cheers,

Jens