Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
My issue is if i have limited data set for currenselected value than the ranking both top and bottom rank shows same values.
But if my ranking is smaller than the actual data then top and bottom works fine.
Can any one help please?
Attached sample example
Gautham
Anyone know how to fix this issue?
That seems quite obvious. Otherwise, what would be your expected output?
Whats your problem exactly.? can you show in your sample your resualt?
Try This:
=Aggr(if( rank(sum(Sales),4,0)<=5 ,Salesman),Salesman)