Creating lists and calculations

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

Recommended Posts

• Newbies

Here's what I am making:

I am trying to get a list summary of our products' sales. For each record I want to put a new product. On the sheet of the record/product I want a list of each months sales. With it I want to insert the month sales and products sold (so unit sales and monatary records). I have made a field for the month of sales and well as each sales thing to track. I want the monthly one to be seen as well as a running total for individual product. But I want to keep this all together on one record. So say the product is a cat and I sold 5 cats one month and 10 the next, it would show 5 units, then 10 units and a running total of 15 at the bottom. Then say the next record after the cat record is dog, I want to be be able to show the monthly units sold as well as the running total for that record. Right now that is what I am trying to figure out. Is there a way to make it that way or do I have to make new records for each month. It seems when I make a list and have the fields, the fields stay identical (i.e.5 all the way down instead of 5, then 10, then 7 or whatever), so I can't add new, distint numbers to each field.

If this makes sense what do you suggest?

Share on other sites

If you just want summaries of sales by month, try creating a new record for each cat sold and recording the date of sale. Make a calc field which calculates the month of the sale, then make a layout with a sub-summary when sorted by Month and a trailing grand summary. Put your Month field into the sub-summary part. Create a summary field = count of ProductName and drop that field into both the sub-summary and the grand summary. Sort by Month and ProductName and print the layout.

This should give you what you want if i understand the question correctly.

Jerry

Share on other sites

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

Create an account

Register a new account

• Similar Content

• Filemaker 6 for Mac issue.

By Tumma K,

• (and 4 more)

Tagged with:

• 8 replies
• 4,097 views
• FM3 upgrade to FM Pro 5.5 - Windows 8 installation possible?

By MrEddByrnes,

• (and 4 more)

Tagged with:

• 4,928 views
• Moving data from fp5 to fp13

By bmill,

• (and 4 more)

Tagged with:

• 2 replies
• 3,250 views
• Filemaker 5.5 database will not delete records on-line

By randyinla,

• (and 4 more)

Tagged with:

• 2,879 views
• Are there still hosting providers for filemaker 5.5?

By randyinla,

• (and 4 more)

Tagged with:

• 2 replies
• 2,622 views
×
×
• Create New...