CDS - Accumulation value from column

[hassin]

Hallo,

I have the current situation/problem and hope you could help me out.

Let's assume we have the following table:

I would like to accumulate the 'Status' in order of the date and when the month change I would like to start with zero:

Which kind of CDS syntax can I use to sum the status and considering the date in right order?

How can I translate this SQL syntax into CDS syntax:

SUM(Quantity) OVER (PARTITION BY AccountID ORDER BY ID)

Regards

Hassin