Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, how to calculate the highest rank and lowest rank in two separate text box?
Min(Aggr(Rank(Field),Dim))
Max(Aggr(Rank(Field),Dim))
,
I tried to work on the same post, and try with your answer
i am getting some wrong answer in my text box, even though answer should be 3 instead of four,because my table EMP have only three departments at all.
can u please help me out why is this gonna happn??
You should get 3. Do you have any other tables linked to your EMP table?
Hi,
Try like this
For Minimum Rank:
=Min(Aggr(Rank(Sum(MeasureName)), DimensionaName))
For Maximum Rank:
=Max(Aggr(Rank(Sum(MeasureName)), DimensionaName)) - 1
Regards,
Jagan.
Hi,
Try this
Regards,
I have one table i.e. calendar linked to it. I think it shoul not affect count at all.
Hi,
My bottom example was for you
Regards,
Yes i have seen your example ... but still in confusion why difference is there, where i am using same approach. it might be because calendar linked table ?
Hi,
It's a possibility, because you have only 3 DEPTNO¿?
If you like you can upload the project and maybe can i help you.
Regards