The RUNSUM function calculates the sum of values for a column in a
running total. The syntax is as follows:
RUNSUM(column_reference or expression. We used RUNSUM to sum all the
values in the specified column in a continuous running total. The RUNSUM
function is identical to the SUM function except for the fact that it
does not reset itself when sub-totalling.
in my case I use RunSum(1), combined with order by I get exactly what I
need to rank my rows.
-Halim