MDX Named Set to find the ratio of Dimension Members

In order to find out ratio of Non-Billable hrs of Various cost type use below named set:

[Measures].[Non-Billable Hrs]/(Root([Tasks]),[Measures].[Non-Billable Hrs]) *100

where Tasks is the dimension name.

 


















Similary in order to find Sales Proportion of different country use the below named set

where Locationis the Dimension name.

[Measures]. [Sales Amt]/(Root([Location]),[Measures].[Sales Amt]) *100