1 Reply Latest reply: Jun 2, 2017 12:19 PM by Sunny Talwar RSS

    Calculate Percentile

    Justin Dallas

      Hello Everyone,

       

      I've got a demo chart where we have Players, and we have a list of their PlayerScores in a game.  What I would like, is that I can have something that says: "Player Two scored in the top 20% of all players".  I've googled till I was blue in the face, and have yet to find anything that matches what I'm trying to do.  I've floundered with the SUM(Score)/(SUM(TOTAL Score) and that only gives me "the percentage of the total score that this players score is responsible for".

       

      I've attached a demo file of some dummy data, but this is what it looks like thus far.

       

      Percentile.PNG

       

      Any help is greatly appreciated.