Hi everyone
I have to estimate the product sales through the sales of other product.
In other words I have a simple table like this:
PRODUCT QUANTIY
A 10
B 20

I have another table that indicate the rules to estimate the quantity of other product.
In other words I have a simple table like this:
PRODUCT PRODUCT RELATED RULES
A AA +3
B BB +1
AA AAA +1
BB BBB +3

I'd like to produce a table like this

PRODUCT RELATED QUANTIY
AA 13
BB 21
AAA 14
BBB 24

Thank you very much in advance