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.
Hi @wendyzjy - Here is what you can do:
@wendyzjy Hope this is what you need.