Help with Table Formula QlikSense?

[alematex]

Hi!

I really need some help with these formula, i believed it could be solved with aggregations but I haven´t reached the good one:

1.- The example data is grouped by Category and Type

2.- These are my Calculations in Excel for 1 category:

3.- The Required Table is like this one:

[aarkay29 · Accepted solution]

sum(aggr((Field1/Field2)*(sum(aggr(Field3/sum(total<Category> Field3),Type,Category))),Type,Category))

[alematex]

Thank You Very Much

This one was the correct one but it was very helpful

sum(Aggr((Sum(Field1)/Sum(Field2))*(sum(Aggr(sum(Field3)/sum(TOTAL <Category> Field3),Type,Category))),Type,Category))