Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

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

Recommended Posts

Posted

I need to make a report with a count of how many unique companies are in each summary field. Here is a simple example. Any ideas as to how I can get FM to do this?

Sales Product 1 Number of Companies: 2



  • company a person 1
  • company a person 2
  • company b person 3

Sales Product 2 Number of Companies: 1



  • company a person 1
  • company a person 4

Posted

its a list of sales to a person that is in a company, I sold product one to three people in two different companies. and product two to two people in one company. the break field is the product ID and I want the count of unique company ID's.

Posted

I guess that means it's a body part. See if you can adapt this to your slightly more complex situation:

http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/page__p__289204#entry289204

  • Like 1
Posted

I guess that means it's a body part. See if you can adapt this to your slightly more complex situation:

http://fmforums.com/forum/topic/61158-number-of-employees-from-payroll-report/page__p__289204#entry289204

Wow that worked! I never would have figured that out! thanks!

This topic is 5014 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
×
×
  • Create New...

Important Information

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