Create running total not associated with timescale

Highlighted
Previous Contributor

Create running total not associated with timescale

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?

1 REPLY 1
Highlighted
Certified Master Anaplanner

RE: Create running total not associated with timescale

[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.