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:
| ClassYear | ClassRank | Quintile |
|---|
2010 | 1 | |
| 2010 | 2 | |
| 2010 | 3 | |
| 2010 | 4 | |
| 2010 | 5 | |
| 2011 | 1 | |
| 2011 | 2 | |
| 2011 | 3 | |
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?
