This content has been marked as final. Show 1 reply
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.