If you are unable to create a new account, please email support@bspsoftware.com

 

Display the value for the lowest member but display all the members of 3 levels

Started by AJ123, 04 Apr 2017 08:46:48 AM

Previous topic - Next topic

AJ123

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

bdbits

If I follow correctly, you might be looking for the parent() function.