Syntax:

ChangeValuesToNTile, boolSortAscending, axis, numberFractiles

Parameters:

boolSortAscending– lowest values go into bucket 1 (true) or highest values (false)

axis – which axis will be used { Row, Column, Page }

numberFractiles - Number of even sized divisions between min and max

Examples:

ChangeValuesToNTile,false,Row,4

The example calculates the numeric range between the minimum and maximum value on each row and divides it into 4 groups, group 1 being the lowest range. Then for each cell in the row, it determines which group the cell falls in and puts the group number in the cell. 

Comments:

There are many terms used for this kind of operation such as histograms and fractiles. More specifically, the results can be referred to as things like “decile” “quartile” etc.