How to calculate weighted value from other rows in pivot table?

[SkyeF9999]

Hello,

 In Qliksense, I would like to calculate the weighted value based on values from rows (toomie1, toomie2 & toomie3).

And only the DCE/Tape value of ToomieAll need to be weighted values, which cost is combination of others. Others get input already.

Table should be like:

Is there any proper way to get this done? I will appreciate it very much! 

Thanks!

Skye

[vinieme12]

Can you also explain how these weights are being calculated?

Why is 22.9 multiplied by 0.2 and not any other number

[SkyeF9999]

hi ~

it just kind of  weights ( maybe <1 or under other possible request) for toomie1~3, and I need it to be flexible for editor