8 Replies Latest reply: Mar 30, 2017 9:52 AM by yves lepape RSS

    How to use rank function

    Prashant k

      Hi,

       

      i have a table as below , I need to rank the suppliers region wise  .So based on average weight, i rank a supplier only specific to that region . So every region would have its separate ranking based on weights.

       

          

      RegionSupplier NameAverage weights
      (Weight*KPI's)
      Rank region wise
      APACxyz17.751
      APACxyz27.52
      APACxyz35.73
      Europeabc44.41
      Americasghi56.31
      Americasghi66.052