Hello experts,
I have a following program hierarchy
I need to create derived values using DRM formula or Java script for the leaf members depending on where they sit in the hierarchy and only when it is either under P6 or P6_2 and update it with the values as shown in the table below. How can I do this?
- When the member P4:Shared-001 is under the P6--> P7-->P8 hierarchy then it should update P1_code, P1_Description
- When the member P4:Shared-002 is under the P6_2--> P9-->P10-->P11_S hierarchy then it should update P2_code, P2_Description
- When the member P4:Shared-001 is under the P6_2--> P7_2-->P8_2 -->P8:Shared-001 hierarchy then it should update P2_code, P2_Description
