There are two ranges of functions available that work in a very similar way to some of the quick options.

The first range is the RUNNING functions, including RUNNING_SUM, RUNNING_COUNT, and so on. These functions aggregate the results that are in cells in the current partition by starting with the first one and running along, updating the calculation and aggregating the results for each new cell. While the running sum is the most obvious example, and is one of the available quick calculations, it can sometimes be useful to use another running function to provide results. For instance, the RUNNING_MAX function is useful when keeping track of a record, as the function will update to the largest value up to the point of the calculation.

For instance, if we wanted to keep track of our record line profit, we could create Record Line Profit as RUNNING_MAX(MAX([Profit]) and add it to a view with MAX(Profit) by Year (Order Date) and Quarter (Order Date). This will show the record to date for the largest line profit ($2,939 until Q2 2011, then $4,630 until Q3 2013, and so on).

The second type of function that should be familiar is the RANK functions, including RANK, RANK_DENSE, and so on. These functions will, as their name suggests, rank the results in the cells based on a given order (either descending (the default) or ascending, as defined by the second argument of the function). Here is a quick summary of how the different functions will rank the same set of data (10, 10, 15, 20) in ascending order: