Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See attached example.
Tks,
That's it. The Join in the script is "the one"