I have a question about the use of advanced formula (aggr), please help!

[#1]

Now I have an urgent question. Please help me.

There is a data source, picture 1

Type, material 1, material 2, amount, cost

Use Qlikview production of the effect of the picture 2, the first dimension, the total amount, cost, gross profit is also very simple, but according to the material 2 gross margin >=60%, and the total 60%> gross margin =>50% count and total amount and accounting

How to write a script to calculate the formula?

I think I need to use aggr, but it's always wrong.

Please help me！

[#2]

Thank you very much for your help, my friend.

I follow your method, do a TYPE list box, separate import and local reports.

But I was curious, in the case of not split report, there is a way to achieve through your formula?

In the end, I wish you a happy christmas!

[#3 · Accepted solution]

Sorry Wrong QVW have a look to the Formulas Tab.

Gilles

[#4]

Thank you very much for your reply, because I did not fully understand your formula, so take a roundabout way, now understand, your reply is very useful to me!

Merry Christmas!