IntervalMatch with Rolling YTD total

Thu, 17 Apr 2014 12:53:14 GMT

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.

Re: IntervalMatch with Rolling YTD total

Thu, 17 Apr 2014 18:26:07 GMT

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