IntervalMatch with Rolling YTD total

[#1]

Trying to achieve the result table in the illustration below:

essentially i'm after a YTD total for each Date in the Sales table.  The From and to dates are defined in the YTDMap table.

I have tried various methods including the use of IntervalMatch but cant seem to get the correct totals.

I have attached a QVW with the inline tables.

Any help would be much appreciated as always.

[#2]

I can see in your Map table, that for each date you want to accumulate last 11 months. Am i right?

I reccomend you to use standard accumulation functionality in this case (comm_acc11_thr_114784.qvw).

If you really need interval math, you will find it in v1.qvd

Let me know if that helps

regards

Darek