I've been able to attach a corresponding field to the MIN/MAX values, which in this case is the player name associated with that value in the set. Where I'm having a problem is when N is even, so the median is the midpoint between the two middle values in the dataset, but since there is no player name corresponding to that value it comes up blank. My thought is that I need to create a calculated field that identifies the top value (i.e. 15th in a set of 30) if N is even, but I can't figure out how to make that function work.
Sure thing, the issue is best shown in the WS Median tab. The field, Player Median, is designed to pull in the player name corresponding to the median value of the WS column. This works fine when the N is odd, but when it's filtered on some picks - 11 in this example - there's an even N, so it's calculating the median as the average of the two middle values, which is fine, but then that value doesn't have a corresponding player name so it's coming in blank.
