Skip to Content
Mar 28, 2017 at 09:22 AM

Excluding the Child Node values from Parent Total in Bex Hierarchy Obejct



We have a hierarchy as below :

+ India 40

A 20

B 10

C 10

Total of India is 40.

Now when i apply report level filter to exclude A it shows as below :

India 40

B 10

C 10

As we see, the Node A disappears from the layout but still the Parent total is unaffected and it still shows 40. Users want India to show as 20 after excluding Child Node A.

I need the output as below :

India 20

B 10

C 10

Please let me know if this can be achieved in webi