Get the ranking for the project

Questions & Answers
,
1

I give all projects to different score, how to get the system ranking for this score? I want to get the ranking for current system. please help, Thanks

2

it is working with below:
Rank([project].currentmember,
order([project].allmembers,[measures].[scores],BDESC))

and I create one new caculated member is [project].[important project] with {project A, project B, project C}, but the ranking still for all projects when I would like to get the ranking for only [projects].[important project],
How to make it working?

3

It is working on with below:
rank([project].currentMember,
order(childrenset([project].[important project]),[measures].[score],BDESC))

Thanks

1 Like