Hi,
i am trying to achieve the below format where the source of the report is dynamic cube and using a crosstab to display the report
membername value
level1 aaa 222
level2 bbb null
Level 2 child bba 111
level3 ccc 444
in the above example i dont have value for level 2 but i have value for level 2 children when i use the following expression to find the lowest child in the hierarchy
filter([Pricecube].[model].[model];count([Actual] within set children(currentMember([Pricecube].[model].[model])))=0)
the expression gives me only the lowest child of the hyerarchy but i want to dispaly all the members of level 1 2 3 but the value should be displayed only for the lowest child
Thanks in advance
If I follow correctly, you might be looking for the parent() function.