Weighted Average where weights are dynamic based on slicer

Hi Anonymous ,

No the developments are the things that I want weighted. Ie I would like a total development column by quarter, weighted by the premium (in the sales data) for each product type. (and for each country/state seperately if selected)

So very simply, if, for example, the slicer were to select product type A and B, I would like the weight for A in the Product Type Development Table to be the total premium for A (in the selected region) divided by the total premium for both product type A and B (in the selected region). So for example, if the US was selected:

These weights would then be applied to every value in the development column for product type A and B respectively.

The final result would then be the sum of the weighted development column for each quarter.

Hopefully this is clearer, but let me know if not, thanks