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% @] }
)
)
)
)
