normalize node's hierarchy

[Former Member]

Hi friends,

I have a very important question for you!

In BEX Analyzer I want to show the hierarchy normalize; but standart it shows normalize to global result. I want normalize to every node.

This example:

index as is to be

A 100 50% 50%

x 70 35% 70%

y 30 15% 30%

B 100 50% 50%

t 40 20% 40%

z 60 30% 60%

Tot 200 100% 100%

Any suggest?

Thanks

[Former Member]

Not,

i want to normalize single value to node father (this it not is partial result).

[Former Member]

Hi

Did you solve this? Im facing the same situation here,

Thanks!

[former_member189638]

Goto the Key Fig Properties and select Calculate Single value as Normalize Sub-Totals.

Tick the checkbox Also Apply to Results and from drop down box select Calculate Along Rows.

One drawback of this is you will get 3 decimal places in teh percentage values since u r using Normalization and this setting bypasses the decimal setting that is done in the properties.

Hope this helps

[Former Member]

Hi Rakesh,

I am also facing the same problem as 3 decimal places. but is there any chance how to make that into 2 decimal places..

Thanks in advance.