Hello!!

Here is what i have:
Dimension:
Name:[Organização Concurso]
Level: [UNR],[RD],[SR]

Measure formula for rank:
Rank([Organização Concurso].currentmember,order({[Organização
Concurso].[Intermediario].members},([Measures].[Pontos do
Concurso]),BDESC),[Measures].[Pontos do Concurso])
But this measure ranks the dimension with all the members of the
dimension.
What i want is:
[UNR] [RD] [SR] [Pontos do Concurso]
A A1 A1.1 40
A A2 A2.1 30
B B1 B1.1 20
B B1 B1.2 10
result of raking:
[UNR] [RD] [SR] [Pontos do Concurso] [Rank]
A A2 A2.1 30 1
A A1 A1.1 40 2
B B1 B1.2 10 1
B B1 B1.1 20 2

How should i do this?
It is possible?

Thanks

André Fonseca

Instead of this:
{[Organização Concurso].[Intermediario].members}

Try this:
{[Organização Concurso].CurrentMember.Parent.Children

public @ the domain below
www.tomchester.net

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote

Thanks!I really nead that....
It works fine!!

But it returns an "#err" in totals and when the dimension is on the
filter area. How should i avoid this?

Thanks in advanced...

Have a good day!

André Fonseca

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

I thought that might be next Try this:

IIF( {[Organização Concurso].CurrentMember IS
{[Organização Concurso].DefaultMember,
NULL,
<formula goes here> )

public @ the domain below
www.tomchester.net

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote

Thanks again!!

Sorry to make this kind of questions but i'm new in this business!!!

André Fonseca

"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

No prob André.

public @ the domain below
www.tomchester.net

"Botinha" <botinha (AT) netcabo (DOT) pt> wrote