A New Home in the New Year for SAP Community!

Exciting times ahead for the SAP Community! We've outgrown our home, so we'll be migrating to a new platform later this year. Let's continue the journey together!

Sep 27, 2007 at 10:51 AM
# Percentages in hierarchies

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