Rank and NTile Functions

Rank and NTile functions are used to qualify a list of values relative to the other values. For example, out of the four quarters in a year, you want to rank total revenue from one to four, with one being the top revenue for the year.

Functions including Rank, Percentile, PercentRank, and PercentRankRelative allow you to view the ranking of values such as a simple integer list or various types of percentages.

NTile functions are used to group the values in an ordered list into one of several buckets or NTiles. Each element in the list is assigned an integer corresponding to the bucket to which it belongs. The various NTile functions differ in how the buckets are defined. Some functions allow you to define the number of buckets, others allow you to define the size of the buckets, and so on.