What I need is a sum of values, taking the previous value and adding to the next.

RANK () OVER (PARTITION BY ORDER BY DATE ASC CODIGO_PESSOA, SUM (VALUE)) THE CUMULATIVE.

NO...