1 Reply Latest reply: Apr 17, 2014 2:26 PM by Dariusz Mielczarek RSS

    IntervalMatch with Rolling YTD total

      Trying to achieve the result table in the illustration below:

       

      interval.JPG.jpg

      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.