2 Replies Latest reply: May 6, 2011 12:10 PM by Oleg Troyansky RSS

    how can i link these? do i need AGGR?

    Amien Amien

      i have 2 tables:

       

      table I:

       

      date, value1

       

      table II:

       

      date, value2, type

       

      i want my pivot chart like this:

       

      dimensions: date, type

       

      expr : sum(value1), sum(value2).

       

      value2, looks ok, but value1 has the problem because there is no type dimension in the source.

       

      how can i split the sum of value1 into type, based on the ratio between types based on the sum of value2 of that day?