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)