Hi,



I use the following MDX to rank the RAV value dynamically but i have a problem, In my Pivot table report when i put the Semi-additive measures next to this, the ranking become zero for every item..



Could somebody help me solve this




iif( IsEmpty( [Measures].[RAV% @])

OR


Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

).Hierarchy.CurrentMember.Level.Ordinal = 0

,

null,

Rank( Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

).Hierarchy.CurrentMember,

Intersect(

Order(

Extract( Axis(1),

Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

).Hierarchy

),

[Measures].[RAV% @],



ASC

),

NonEmpty(

Axis(1).Item(0).Item( Axis(1).Item(0).Count - 1

).Hierarchy.CurrentMember.Level.MEMBERS,

{ [Measures].[RAV% @] }

)

)

)

)