You can also use over to do rolling aggregation on another table than Day. Ex: Month.NetAmountLast2Y= sum(Month.NetAmount) over month = [-23..0]
You can also use over to do rolling aggregation on another table than Day.
Ex: Month.NetAmountLast2Y= sum(Month.NetAmount) over month = [-23..0]