Hi to all,
We want to be able to calulate [SALES] of a certain sub-department divided over the total of that DEPARTMENT.
We need to have this done dynamically depending on the values of the SUB-DEPARTMENT and DEPARTMENT parameters choosen by the user.
Is this possible or not ? This is what i think might do what i want but can’t seem to make it work correctly:
currentMember ( [Cube_Sales].[ProductDimension].[Produit_Level] )
parent ( currentMember ([Cube_Sales].[ProductDimension].[Produit_Level] )