Group By with Filemaker

Question

How can I use Group By with FileMaker? Kind of similar problem like this Filemaker sum by group. Can someone explain how to use Summary GetSummary?

Id |Value

1 |50

1 |50

2 |10

2 |5

1|100 2|15

Answer 1

1. Create a new summary field (ValueSummary) for Value field.
2. Sort the records by ID field.
3. Use GetSummary ( ValueSummary; ID ) to get the summary of a particular ID value.