Hi,
as in Analytics Formula doesnt support this SQL for cumulative calculation.
SUM /*Balance as of today*/({amount}) OVER (ORDER BY {trandate} ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW)
Please advice how to calculate same in Analytics Workbook?
Customer require a Line Chart with a cumulative month Sales.
Cheers
Janne Paananen