Weighted average - multiple category

Hi,    i am trying to do a weighted average with mulitple categories. I need to multiply the "proportion" by the "capability" depending on filters selected. I have 3 filters: location, platform and...