I'd like to create a field (a calculation/summary field?) that
calculates the total value of a field Z whose field X matches a grouped
value.

e.g.:

x: friuit y: banana z:19
x: friuit y: apple z:10
x: vegetable y: carrot z:3
x: vegetable y: tomato z:12
x: vegetable y: squash z:2

therefore, the totals woul be:
fruit: 29
vegetable: 17

and th aggregate calculation field would compute as:
x: friuit y: banana z:19 c_aggregateField: 29
x: friuit y: apple z:10 c_aggregateField: 29
x: vegetable y: carrot z:3 c_aggregateField: 17
x: vegetable y: tomato z:12 c_aggregateField: 17
x: vegetable y: squash z:2 c_aggregateField: 17


however, I'm stumped as to how to implement this in Filemaker.

any ideas?

thansks in advance.

You create a relationship in the same file (self relationship) based on
the 'group' on both sides, and a field named 'aggregate' =
SUM(relationship::group)
Remi-Noel
(I may send you the little example I made to verify that, if you give me
a real address)


"grasshopper" <bob (AT) nowhere (DOT) com> a écrit dans le message de news:
2005081800594216807%bob (AT) nowherecom (DOT) ..

you're The Man, Remi (http://www.themanmovie.com)

that worked like a charm, I always wondered how to do that.

thank you!
b.

On 2005-08-18 02:01:57 -0700, "Remi-Noel Menegaux" <rnmenegaux (AT) free (DOT) fr> said: