Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=IF (aggr(rank( sum(Value) ,0) , Value )<= 5 , sum(Value) )
how it is calculating pls explain me step by step?
=IF (aggr(rank( sum(Value) ,0) , Value )<= 5 , sum(Value) )
Lets Start From the Inside Function First
SUM(Value) : Sum of Value
Rank(SUM(Value) ,0) : This will allocate Rank against each SUM(Value)
Aggr(Rank(SUM(Value) ,0)) : This will create a Virtual Table as below format. (Dummy values are given for your understanding)
SUM(Value) Rank
100 1
95 2
80 3
etc...
Now
IF (aggr(rank( sum(Value) ,0) , Value )<= 5 : will check that which are the lines from above Virtual Table falls (Rank <=5)
Whatever SUM(Value) is having Rank <=5 , will only be displayed...
Let us know if this is still not clear...
Hi,
Go through this attached application yo will understand.
Regards
ASHFAQ
=IF (aggr(rank( sum(Value) ,0) , Value )<= 5 , sum(Value) )
Lets Start From the Inside Function First
SUM(Value) : Sum of Value
Rank(SUM(Value) ,0) : This will allocate Rank against each SUM(Value)
Aggr(Rank(SUM(Value) ,0)) : This will create a Virtual Table as below format. (Dummy values are given for your understanding)
SUM(Value) Rank
100 1
95 2
80 3
etc...
Now
IF (aggr(rank( sum(Value) ,0) , Value )<= 5 : will check that which are the lines from above Virtual Table falls (Rank <=5)
Whatever SUM(Value) is having Rank <=5 , will only be displayed...
Let us know if this is still not clear...