Create 2 levels of grouping

[sacosta5]

Hi, I  have the following information, and I nedd to create two levels of grouping:

1) level (NIVECODIGO)

2) dependence of the delegation father (DELE_NUM_PADRE)

The result to be obtained is the next in a pivot table:

Anyone have any suggestions?

THANK YOU!

[swuehl]

You may want to look into the HIERARCHY LOAD prefix:

Unbalanced, n-level hierarchies

[miguelbraga]

Hey Silvia Acosta,

Add something like this in your script:

     If(NIVECODIGO = 1, DELE_NOM, null()) as Nivel1,

     If(NIVECODIGO = 2, DELE_NOM, null()) as Nivel2,

     If(NIVECODIGO = 3, DELE_NOM, null()) as Nivel3

And then construct a table like your result

Thanks,

MB

[sacosta5]

Hi Miguel,

Thanks for your suggestion, but it does not solve the second level of grouping. Also I need to use DELE_NUM_PADRE.

Silvia,

[sacosta5]

Thanks Swuehl...

Thanks for your suggestion, I´ll take a look.

Silvia