Problem with set analysis in table

[#1]

Hello,

I have a problem with a column in wich I am using set analysis. I attached an example with my problem.

I have two tables, "Epigrafes" and "Movimientos". Both are related by the column Cuenta.

What I need is to modify the expression of column "Total" in the table "Resultado" to display the sum of the amounts ("Importes") for column related FilaTotal.

Example:

This is what I need. Rows 3, 4 and 5 have to show the sum of row 5. And 6, 7, 8 and 9 rows the sum of row 9.

I've tried with the expression: =SUM({$<Epigrafe=,Orden={'=FilaTotal'}>}Importes)

but it doesn't works.

Can you help me?

Best regards,

Oscar Iglesias.

[#2]

This solution is not valid, to use the "max" does not always return the correct value. If the amount change sign as deputy qvw that no longer works.

Some solution.

[#3 · Accepted solution]

Hello,

Please try with this expression

=sum( total <FilaTotal> match(FilaTotal,Orden)*Importes)

you have to add in your chart the dimension FilaTotal, but you can hide the column if it is a problem

Regards,

Benoît

[#4]

Thank you very much for your answer, it works.

Regards,

Oscar Iglesias.