Summary depending och another field

[boma]

Hello, I'm sort of new to FileMaker and are now evaluting what it can do for me. So far it looks good but now I have a problem. I want to do a summary. But the summary is depending on a category in a third field:

Category       Amount         Summarized amounts

A              10             30

B              5               20

C             15              60

C             30              60

B             15              20

A             10              30

A             10              30

C             15              60  

The Summarized amounts field should calculate the amounts for all A:s, B:s and so on separatly and display the results in all records.

I need to make this working without searching because another table needs the summarized data.

I hope you understand what I mean and that somebody could spare some minutes to get me back on track.

[-Queue-]

You need to create a self-relationship on the Category field, then create a calculation field of Sum(self_cat::Amount) to sum all related Amounts.

[boma]

Thank you for the help. But I still can't make it working. I need someone to walk me trough it with all steps included to see what I am doing wrong.

[-Queue-]

Stuff your file and attach it to this thread. We'll make the changes so you can see how it's done.

[boma]

Okay. Here it is. It is written i swedish so i must make some clarifications. It is in the table "Provdefinitioner" that that the field "Viktber

Register.fp7.zip

[-Queue-]

I've added a self_Kurs|Provdefinitioner table reference, which matches the Kurs field to itself in the Provdefinitioner table. Then I changed the Viktber

Register.zip

[boma]

Thanks Queue. Sometimes the solutions are just too obvious.

[-Queue-]

No problem. Now you'll know how to do it the next time.