Showing weeks up to the selected week number

[richard_chilvers]

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.

Ideas are welcome.

Richard

[Anonymous]

Use Intervalmatch() function

[richard_chilvers]

Hi

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.