Former Member

# Hierarchy Aggregation

Does anyone know if you can display key figures through a hierarchy but turn off the natural summation of the key figures through the hierarchy? ie. you see the figures at the lowest level but zeroes on the nodes above the lowest level.

10|10000 characters needed characters exceeded

### Related questions

Former Member
Posted on Sep 05, 2005 at 07:13 AM

Hi Andrew,

in BEx you can use a calculated keyfigure with the boolean Operator LEAF.´

The formula should be like this:

'keyfigure1' * LEAF( 'keyfigure1' )

regards

Alex

10|10000 characters needed characters exceeded
• Former Member
Posted on Nov 03, 2005 at 05:32 PM

I am 3.1C and dont see LEAF in the formulas, is there any other work around or procedure to achieve the above.

10|10000 characters needed characters exceeded
• Former Member

You can Find it under Boolean Operators..

<b>1 with Individual Values, 0 with aggregated values</b>

Thats the LEAF function...

Ashish..

• Posted on Jul 03, 2007 at 02:20 AM

Hi All

Further to the LEAF solution, instead of supressing the natural summation with zeros, how can I replace the natural summation with the average of all values on each hierarchy node ?

EG

Cost Ctr Group Hierarchy Node, Key Fig = 25 % (the average)

Cst Ctr 1, Key Fig = 60 %

Cst Ctr 2, Key Fig = 20 %

Cst Ctr 3, Key Fig = 10%

Cst Ctr 4, Key Fig = 10%

Cheers

Ricky