Something Like This
Drag to Filter and Set TRUE
1 of 1 people found this helpful
To expand on what Deepak suggested, if you want to have the whole list still display on the sheet, but identify that 80th guy on the list,
WINDOW_SUM( if INDEX() = [your calc where you identify the 80th percent guy] then SUM([score]) END )
If your score is already an aggregate calc, then you don't want to so SUM(). Just do [Score] in that calc.
Thanks Joe and Deepak! Your help got me the info I was looking for.