This content has been marked as final. Show 12 replies
I am trying to get the bottom 10 service levels for our Items supplied by various vendors. which is basically Supply vs demand for each vendor for YTD. I am using the Rank function as mentioned below
=AGGR(IF(Rank(-(Sum(AVAILABLE)/Sum (DEMAND)),4)<=10,ITEM), ITEM)
The top 10 works fine. but for bottom 10 i get just 1 record where the available is in -ve. therest 9 records do not show up.
if i create a simple table and i check the records, there are various items which satisfy the criteria and they should show up.