Different groups, different weight

[Allan Andersen]

I'm a heavy Excel and gSheet user. My system is currently based on gSheet and I tried to structure it in a database style. My issue is now that I start to get too much data which slows down everything and creates errors. So I'm trying to educate myself in SQL and moving myself in that direction.

A major issue for me before really taking this step is the below.

I have 3 groups each having a weight of:

Group 1 25%
Group 2 20%
Group 3 55%

So having 100,000$ in total and by that 25,000$ should be in group 1.

On top of that, within each group, there is an A or B. An A should have an allocation of 75% vs a B - and within that group.

How would you do that in that in MySQL? And I would like the value and the in % to be used later on.

Since this is my first post, I'm not sure how to share an example. But I'm very happy for any help and support from you.

Allan, Sweden