Filter values from one column based on values from other two columns

[#1]

Hi to All,

I have two tables:

One containing the day bay day sales:

ID	Client	Date	Sales
1	Name1	1/15/2013	50
2	Name1	2/15/2013	100
3	Name1	5/15/2013	100
4	Name1	7/15/2013	50

and one containing the targeted budgets by Client for different periods of time:

Client	Budget	StartDate	EndDate
Name1	1000	2/1/2013	6/1/2013
Name2	2000	3/1/2013	8/1/2013

I need to create a chart having the dimension Client, Stard Date & EndDate and as expresion to calculate the SUM(Sales) restricted by the timeframe given by StartDate and EndDate of the trageted budget.

In above example, I need to get the sum for rows with ID 2 and 3 which has the Date between corresponding StardDate and EndDate from Client "Name1" (and so on for each client).

Do you know if there is a way to do that using Chart object?

Or I need to do this during loading script?

Thanks in advance

Laurentiu

[Gysbert_Wassenaar · Accepted solution]

See attached example.

[#3]

Tks,

That's it. The Join in the script is "the one"