In my report client need Level4,3,2,1 of the center dimension in 4 separate columns. But the problem is in the report the center level did not come as per exception. For reference, I
attached the screenshot.
In the below screen short in Executive Committee is level 4 of the center is correctly shown in the report but when you observe in column 7 i.e Division (Level 3) is shown the same member for all.
For Example, C_CAP is level 4 and it child is C_D240( Level 3) it is correct but when check other members like C_FUND is level 4 and it child shown C_D240 (Level3) is not correct it child is different I.e C_E400.