HI friends,
I have product dim(in row), time(in col), qty/rate/amout(act dim member ids in col).
Product jan2010(qty) jan2010(rate) jan2010(amount).......dec 2010(amount)
p1 30 5 150
p2 10 5 50 ..
p3 20 5 100 ..
written script logic for each month wise, getting amount for p2 and p3.
P2 amount = P2 qty * p2 rate
P3 amount = p3 qty * p3 rate
Here p1 is parent of p2 & p3.
P1 qty should be summation of p2 qty & p3 qty.
P1 rate should be avg of p2 rate & p3 rate.
P1 amount should be summation p2 amount & p3 amount.
By default P1 qty, p1 rate & p1 amount are aggregated up. But i want p1 rate as avg of p2 rate & p3 rate.
Can it possilble by scipt logic or i have to simple excel for p1 rate calculation?
Thanks,