Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Perhaps this?
If(GetCurrentField([Drill group Name]) = 'Country', Sum(Measure), If(Rank(Sum(Measure)) <= 5, Sum(Measure)))
May be this
If(GetCurrentField([GroupName]) = 'Country', Sum(Sales), If(Rank(Sum(Sales)) < 6, Sum(Sales)))
Perhaps this?
If(GetCurrentField([Drill group Name]) = 'Country', Sum(Measure), If(Rank(Sum(Measure)) <= 5, Sum(Measure)))
Thanks for you help.
Thanks for your help