Subscribe Bookmark RSS Feed

byVar

camlesse

Community Trekker

Joined:

Jan 20, 2016

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:

ClassYearClassRankQuintile

2010

1
20102
20103
20104
20105
20111
20112
20113

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

hi camlesse

follow this path:

Calculating Col Quantile by columns

Best,

ron

3 REPLIES
Solution

hi camlesse

follow this path:

Calculating Col Quantile by columns

Best,

ron

camlesse

Community Trekker

Joined:

Jan 20, 2016

Thanks Ron.  Very helpful!

markbailey

Staff

Joined:

Jun 23, 2011

The Summarize() function is also simple to use but quite powerful when you have a By variable to consider.

Learn it once, use it forever!