I have this source table:
January 10 , 5
April 15, 1
And we need to make a simple table calculating a formula like
sum(Amount*Percentage)/sum(Amount) accumulated by month.
The result table should be something like:
January 5 --> (10x5/10)
February 5,16 --> (10x5+20x4+30x6)/(10+20+30)
March --> 4 (10x5+20x4+30x6+56x2)/(10+20+30+56)
How do I configure the expression?
Notice that in the new table there is no any accumulated colum.