Cumulative total in a query table

Cumulative total in a query table

Hello there,

I would like to calculate a cumulative total of the column "elmCount" per customer in order to check when the total of the elmCount exceeds the limit. There is one limit per customer. In a normal SQL environment I would do it as follows:

Source table:



SELECT query:



I'm currently despairing about the implementation in Zoho Analytics. How can I do that there?
I am very happy about answers and help!

Best regards,
Sven