Can we set rank on Second dimension in Dimension Drill Down Group

[alis2063]

I have got the requirement  that we have shown Group of  dimension as Drill Down Group  and  set the rank on second dimension,

Suppose we have 2 dimension  here,

1)Country

2)Sales Person

We have defined the drill down group on above dimension

if  i click on country  then we  should have only Top 5 sales person.

[sunny_talwar]

May be this

If(GetCurrentField([GroupName]) = 'Country', Sum(Sales), If(Rank(Sum(Sales)) < 6, Sum(Sales)))

[Anil_Babu_Samineni · Accepted solution]

Perhaps this?

If(GetCurrentField([Drill group Name]) = 'Country', Sum(Measure), If(Rank(Sum(Measure)) <= 5, Sum(Measure)))

[alis2063]

Thanks for you help.

[alis2063]

Thanks for your help