See this link on a "summary recap" feature: FMP 12 Tip: Summary Recaps (Portal Subtotals)
As to which part?
If you have a multi page report you could:
Put it in the title footer to see it at the bottom of only the first page
put it in the footer to see it at the bottom of every page
put it in a trailing grand summary to see it immediately after the last record listed in the body.
I want my field to count only "Active" s. It is now counting all entries. How do I make it count only "Active?"
Please see the details of the link that I have provided for a summary recap.
So sorry. I'm not very advanced in FM. That explanation is much too complicated for my place on the FM learning curve. I just don't understand it.
I have created a field named, "Count Membership Type." That field appears in my Trailing Grand Summary, and I want it to count how many times the word "Active" appears in my field, "Membership Type."
The method described in that link does not use such a summary field. It uses an ExecuteSQL query in an unstored calculation field. While SQL may be unfamiliar to you, it's actually simpler in this instance than the nonSQL alternative. The alternative requires adding a table with one record only for each of your "category" values and then you set up a portal to that table with relationships and an extra table occurrence of your report's table that allow either a summary field in your report's table or a calculation field with Count() in this new table to produce the correct counts.
What can make this even more complex is if your report, as is usually the case, is not based on all records in your table but rather a subset of the total. It can be tricky to set up a relationship that links by category while still only linking to the same records in that category as are used in your report.
So what type of criteria do you specify when setting up your report? (Or would you rather try ExecuteSQL after all.)