Hi, I've been battling a problem that is getting urgent to solve. I need to accumulate orders per week per Category. Category A will only accumulate the A values etc. I'm using aggr(rangesum(above from 0 to rowno() per week and category. This works fine until the category doesn't have any orders in a week. The aggr() funktion returns a null value.
This is part of a larger expression where I will need to have all values aggregated per Week and category so basing my expression on another column will not work.
This works but leave gaps in the table.
I tried to set null values to 0 but the best I get duplicates my values.
As you see on week 49 A, it should be reduced by the value the previous week.