byVar<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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?
Re: byVarThe Summarize() function is also simple to use but quite powerful when you have a By variable to consider.
Re: byVarThanks Ron. Very helpful!
Re: byVarhi camlesse
follow this path:
Calculating Col Quantile by columns
Best,
ron
