Create running total not associated with timescale

PrevContributor

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?

Mark_W_Shemaria

[quote=Mitch Max]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?[/quote]

Transactions are grouped in 15 minute increments in order to achieve level of precision of the measure.