We are looking for a way to assign decile values to transactions where the order of a measure in a module determines its ranking. We cannot use the RANK() function (without a subset workaround) as the number of transactions exceeds 1M. The CUMULATE function only applies on a timescale. Has anyone found a way to do this? For example, a cumulative percentage or a pareto calculation?