Jump to content

Sub Summary showing Individual Records


This topic is 2300 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 2300 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.