I'm in campus recruiting and we have divided our target schools into three levels (National, Regional, Local).
I'm creating scores for our target schools based on how they compare to the school level's average.
I'm able to create the formulas in a table view using ALLSELECTED(Schools(School))...