Sub Summary showing Individual Records

[jagstirling]

Hi,

I am a newbie to FM, pease excuse my ignorance!

I have a table of data;

REGION | SALES

A | 500

A | 400

A | 300

B | 600

B | 700

C | 300

C | 200

 

I am tying to produce a report that will show

REGION | TOTAL AMOUNT

A | 1,200

B | 1,300

C | 500

 

I have attached my meagre efforts but as you see, the report I have built doe snot produce the desired result. I have added a TOTAL SALES field to my table but I cannot get the result that I desire.

What have I done wrong?

 

 

Test.fmp12

[doughemi]

1. Put the Region and Total Sales fields in the Subsummary part of the layout.

2. Delete the Body part.

3. Change the layout to List view instead of Form view.

4. Sort the data by Region.

[jagstirling]

Thank you doughemi

Accessing the sort through the Browse view was the missing part for me