9 Replies Latest reply: Jan 12, 2017 1:54 AM by Panwipa Wattthanapranwong RSS

    How to do: calculate %rank & count people

    Panwipa Wattthanapranwong

      Data

       

      NameTierTargetAmount
      DerekA10070
      MaleeB1,000100
      JoeB1,000400
      GillA200150
      MikeA10010

       

      Result


      Calculate % from amount/target and then count person by tier & rank as below

       

      Tier>=50%<50%
      A21
      B02