How to do weighted calculation

Question

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

Table 1 - ValuesCustValueCust A50Cust B80

Table 2 - Monthly WeightCustMonthWeightCust AJan50%Cust AFeb30%Cust AMar20%Cust BJan40%Cust BFeb15%Cust BMar45%

Output  CustMonthValueCust AJan         25.0Cust AFeb         15.0Cust AMar         10.0Cust BJan         32.0Cust BFeb         12.0Cust BMar         36.0

Maskell_Rascal · Accepted Answer

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