I have a table of orders, including product and date ordered.
In my chart I show each product and the weekly order total. The user can select the week or weeks. So they can select week 6 and see all orders for that week.
I would like to add a column which shows all orders up to the selected week (ie. for weeks 1-6). I cannot use set analysis to filter out the week selected, because the table may show orders for weeks after week 6.
I have used Intervalmatch in other models - but only within the script. In this case, the week number of each order is clearly defined, but I am struggling how best to build the correct expression which selects the weeks I have described.