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?