Skip to Content
0
Former Member
Sep 27, 2007 at 10:51 AM

Percentages in hierarchies

25 Views

Hello all,

I have the following scenario with a hierarchie:

Keyfigure A

ROOT 200

Level 1 200

Level 1.1 80

Manager A 20

Manager B 60

Level 1.2 120

Manager C 80

Manager D 40

What we want is to get the percentage of each manager over his group (Level 1.1 or Level 1.2) and over his area (Level 1). I mean:

For manager A : the percentage of 20 over 80

the percentage of 20 over 200

For manager B: the percentage of 60 over 80

the percentage of 60 over 200

For manager C: the percentage of 80 over 120

the percentage of 80 over 200

For manager D: the percentage of 40 over 120

the percentage of 40 over 200.

How to get this keyfigure using hierarchies?

Any idea?

Thanks in advance.

Carmen