Please excuse the simplicity of the request. I am trying to use a column formula to determine the quintile for a column of values that are divided into specific groups in another column. The data look something like this:
I want the formula in the quintile column to determine in what quintile the class rank is depending on the year. I cannot get the correct syntax in the formula to make the calculation. All attempts to use Quantile [;ClassRank, :ClassYear] result in only Class Rank appearing in the column formula. Any suggestions?
The Summarize() function is also simple to use but quite powerful when you have a By variable to consider.