Sort calculation of total per type – result won’t show for all types

[hag]

I am trying to have a list that would show the sum of records sorted by type.

The DB has two tables "list" and "list line". "list line" is self joined to "List_line_Type" based on the fk ListID and Type. The sum field for Type is a calculation field: Case (Type = 1 ; List_line_Type::Total) and Case (Type = 2; List_line_Type::Total).

Next I want the sum as sorted by type to show in the List table. The fields are defined as calculation filed = List_line_Type::Tot_type1 and ...Type 2.

While the right results appears in the List_line table, they will not show correctly on the List table. It's as if FMP only evaluates the first related record and hence shows the calculation of the Type of that first record ignoring the rest.

What am I doing wrong?

List.fp7.zip

[comment]

There are several ways to do this - here's one:

List.fp7.zip

[hag]

Thanks! it works perfectly