Calculated Dimension

[tmumaw]

I have this calculated dimension and I am interested in only ranked values between 2 and 10.  I'm using this to get my top 10.  Is there a way of only getting 2 - 10?

=if(aggr(Rank(Count(DISTINCT([Requisition]))),[SF_Job]) < 11,[SF_Job])

[sunny_talwar · Accepted solution]

May be this

=Aggr(If(Rank(Count(DISTINCT [Requisition])) > 1 and Rank(Count(DISTINCT [Requisition])) < 11, [SF_Job]), [SF_Job])

[tmumaw]

Thanks Sunny that worked.  Do you know of a way to start the ranking at 2 vs. 1? 

[sunny_talwar]

May be just add 1 to the Rank?

RangeSum(Rank(...), 1)

or

Rank(...) + 1