Is it possible to perform window aggregate functions like sum YTD (year-to-date)? For instance I want to know the accumulated sales volumes over a region up to each day of the year.
My SQL approach would be: SUM(sales amount) OVER (PARTITION BY year, region ORDER BY date)
1 Like
It is possible using the “Running Total” transformation. See the example below:
month-to-date.morph (2.1 KB)
1 Like