[Solved] Libreoffice Base: Cumulative sum

[yellowhat]

Hi all, I am new to libreoffice base, so I decided to ask you an advice. I want to create, in a query, a new column with cumulative sum such as:

A SUM
1 1
2 3
3 7

Could you help me?

Thanks

[John R. Graham]

Moved from Other Things Gentoo to Desktop Environments. Not about Gentoo so it fits better here (I think).

- John
_________________
I can confirm that I have received between 0 and 499 National Security Letters.

[yellowhat]

Any ideas?

[wizulis]

If I understand correctly what you want, then it is pretty easy:

Assuming that the

"A" is in cell A1 and "1" is in cell A2 and "2" is in cell "A3" just write in B2

=sum($A$2:A2)

Then push enter, select the cell again and pull it down by the square in the right bottom corner of the cell.

[yellowhat]

Thanks for reply but my question was about creating a query in libreoffice base not calc.

[yellowhat]

Anyone know how to write this query in sql for libreoffice base?

[yellowhat]

This is quite good:

SELECT "ID", "Quantita", (SELECT SUM("Quantita") from "Tabella1" WHERE "ID" <= "ID") AS "Running Total"
from "Tabella1"

But as result I get:
1 10
2 10
3 10
4 10

It is not progressive but something must be changed here: WHERE "ID" <= "ID"

[yellowhat]

This works perfectly