CumeDist

Compute the cumulative distribution of the input column. The cumulative distribution is a number between 0 and 1. The last row is always 1.

Usage

CumeDist(column, [direction])

column (required) The column used to order the table.

direction (optional) The direction to sort the input column. Enter in “asc” to sort ascending and “desc” to sort descending. Default sorting is ascending.

Example

CumeDist([Population 2010])
CumeDist([COUNTY - Count])

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us