Dimension Limitations - Alternative Dimensions

[laura_1]

Hi,  

I have a chart with multiple alternative dimensions which I'd like to limit based on a specific calculation which is not the chart measure calculation. At the moment, the only way I could think of limiting it is with nested if statements like so:

If(GetObjectField(1)='Dim1', 

then sum({<Dim1={="Rank(calculation)<10"}>}), 

If(GetObjectField(1)='Dim2', 

then sum({<Dim2={="Rank(calculation)<10"}>}), 

If(GetObjectField(1)='Dim3', 

then sum({<Dim3={="Rank(calculation)<10"}>})

etc.

Is there a way to limit alternative dimensions without all these nested IF statements? 

Thanks in advance!

[sunny_talwar · Accepted solution]

How about just this

Sum({<[$(=GetObjectField(1))] = {"=Rank(calculation) < 10"}>} Measure)

[laura_1]

It worked, thanks so much Sunny!