Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Could anyone explain what does this formula do?
=If(Aggr(Rank(-Sum(Sales)) <= 20,Salesman),Salesman)
Thanks in advance.
Bottom 20. I.e. 20 salesmen who performed worst (minimum sales).
I think it shows the top 20 Salesmen (e.g. as Dimension) based on their sum of sales but also based on an inverse ranking of sales (so last rank becomes first rank)
Bottom 20. I.e. 20 salesmen who performed worst (minimum sales).