What kind of value list format are you using? a CheckBox Set?
And am I correct that you want the count over a found set of records, not just the values selected in a given checkbox set?
It's a drop down. It will be a found set of records.
Then a summary report with a "count of" summary field and a sub summary layout part "when sorted by" this field can be used to get your counts. You'd delete the body layout part in order to get just one row for each value used.
If you need this list as part of a more complex report, you can set up a filtered portal (fileMaker 11) or a calculaton field using Execute SQL (FileMaker 12).
If you used the portal, you'd need to create a related table with one record for each value in your value list.
What if i want to go one step further.
Take all of the activites within a found set : sub summarize by rep who entered the activit (text field) ; then subsummarize the contact type per rep.
Phone Call 2
It's very easy to set up as a summary report.
You'd need one sub summary layout part when sorted by Rep (put the name field in this part)
and one sub summary when sorted by Type (put the Type and summary field in this part)
THen sort your records first by rep, but also by Type.
And don't forget to remove the body layout part.
Thanks. This does summarize by rep and give me the granf total of the "type" field, but it does not seperate out the value list options that are used on teh drop down for the "type" field. It's only providing the type in the first related record, not each value listed in that field.
What related records? That's the first I've heard of related records in this thread.
I've assumed that your report was done from a layout based on the table in which you have defined your type field. Please describe the tables involved and how they are related.
Ah! That was my problem. It pulled the records from the origional layout and it works.