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:



      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.