How to do weighted calculation

[anamik72]

I have table 1 and 2 as below. I want to get output as mentioned below. Can you help? Thanks

Table 1 - Values
Cust	Value
Cust A	50
Cust B	80

Table 2 - Monthly Weight
Cust	Month	Weight
Cust A	Jan	50%
Cust A	Feb	30%
Cust A	Mar	20%
Cust B	Jan	40%
Cust B	Feb	15%
Cust B	Mar	45%

Output
Cust	Month	Value
Cust A	Jan	25.0
Cust A	Feb	15.0
Cust A	Mar	10.0
Cust B	Jan	32.0
Cust B	Feb	12.0
Cust B	Mar	36.0

[Maskell_Rascal · Accepted solution]

Hi @anamik72 

This might be to basic for what you're data needs, but you can use a Join and Formula tool to get to the weighted averages. 

Let me know if this works for you. 

Thanks!

Phil