This content has been marked as final. Show 2 replies
Hi to All,
I have two tables:
One containing the day bay day sales:
and one containing the targeted budgets by Client for different periods of time:
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