Weighted Average

[wendyzjy]

hi Experts,

Would like to ask for some advice on calculating the weighted average rate for vertical and horizontal sum up amount. I used weighted average tool but couldn't get an ideal result. Details input as attached.

[ArtApa]

Hi @wendyzjy - Here is what you can do:

[Qiu]

@wendyzjy 
Hope this is what you need.