Variable in set analysis with aggregation

[Anonymous]

Colleagues, good day!

In my dummy model i have two tables:

//Table with settings

Set:

LOAD Id,

     EndDate

FROM

Test.xlsx

(ooxml, embedded labels, table is Settings);

//Table with sales

Sales:

LOAD Id,

     Date,

     Sales

FROM

Test.xlsx

(ooxml, embedded labels, table is Data);

In qvw i created variable vComp, which calculate the date week before based on EndDate.

is it possible to calculate in set analysis sum of sales for those Dates >=vComp. The idea - value of this variable should be aggregated by Id, because One Id could have several vComp values.

Thanks!

[sunny_talwar]

So how would the find table look like? Would you be able to share expected output in an Excel file?

[Anonymous]

See please new input file and output.
set analysis should calculate data only for yellow cells.

Thanks.