Creating a column which displays the cumulative yield The cumulative yield would be calculated as such : ( sum of yield of passing result types for temperature 1 ) * ( sum of yield of passing result types for temperature 2 ) * ( .....

The data input and my intended table view are as attached as INOUT image file.

More information for understanding :

Several units of specific ID are put through tests at different temperatures.

The results are indexed and index numbers <50 are considered desirable / passes

If you refer to the attached image file , you can see that i want to create a table which reflects the yield percentage of each passing result type, under each temperatures. Yield is calculated as the(result count / total units tested ) .

I am having trouble displaying an additional column which tells us the cumulative yield for each ID.

The cumulative yield would be calculated as such : ( sum of yield of passing result types for temperature 1 ) * ( sum of yield of passing result types for temperature 2 ) * ( .....