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.
Any help is greatly appreciated.