how can i link these? do i need AGGR?

[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?

[IAMDV]

Have you considered using Indirect Set Analysis? I had used the Indirect Analysis for similar requirement.

Good luck!

Cheers - DV

[Oleg_Troyansky]

Amybe something like this?

sum(Value1 * Value2) / sum(total <Date> Value2)

This shoud work, I think...