Multiple SUMIFs

Hi,

I want to create a column within a table which is a tag or checker on whether an Opp ID has a majority sold of one product. I have created an excel table to simulate this.

In my data I have the Opp IDs e.g. Opp 12, Opp 23, and the price of each product with a label for the product. I do not have the percentage column or if a certain product is the majority of that opportunity.

I don't need the percentage column necessarily, mainly the "Majorty Yes or No?" column. What this column does is sees what percent of the Opp is network based, it then compares it to my chosen threshold e.g 90% and says yes or no.

Please can someone help me recreate this column in the query or custom column within view tables.

Thanks, Tom.