2 Replies Latest reply: May 29, 2013 9:29 AM by Laurentiu Gheorghiu RSS

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

      Hi to All,

       

      I have two tables:

      One containing the day bay day sales:

       

      IDClientDateSales
      1Name11/15/201350
      2Name12/15/2013100
      3Name15/15/2013100
      4Name17/15/201350

       

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

       

      ClientBudgetStartDateEndDate
      Name110002/1/20136/1/2013
      Name220003/1/20138/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