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