Conditional Weighted Average using same Data Column

[Googsy]

Hello!

I try to do a weighted average of data in a single column.

Example:
[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD]Module[/TD]
[TD]Indicator[/TD]
[TD]Type[/TD]
[TD]Data[/TD]
[/TR]
[TR]
[TD]M1[/TD]
[TD]Ind 1[/TD]
[TD]A[/TD]
[TD]100[/TD]
[/TR]
[TR]
[TD]M1[/TD]
[TD]Ind 1[/TD]
[TD]B[/TD]
[TD]80[/TD]
[/TR]
[TR]
[TD]M1[/TD]
[TD]Ind 2[/TD]
[TD]A[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]M1[/TD]
[TD]Ind 2[/TD]
[TD]B[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]Mn[/TD]
[TD]Ind n[/TD]
[TD]X[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Simply put, I need to do weighted average per Type for Indicator 2 using Indicator 1.
The Module condition is required as same indicator-type may be in different modules but different unit of measures. so, the consolidation is done per module.

I listed only the conditional columns. The set of modules-indicators-types-data is repeated multiple time for each Location in scope! Therefore this consolidation will show overall result.

Looking forward for the saving net I thank you in advance and I wish you a great day,
Dragos