Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
sum(aggr((Field1/Field2)*(sum(aggr(Field3/sum(total<Category> Field3),Type,Category))),Type,Category))
sum(aggr((Field1/Field2)*(sum(aggr(Field3/sum(total<Category> Field3),Type,Category))),Type,Category))
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))