Dear all,

I am having an issue about how to count a sub-summary header but yet I forgot how to do it.

I attached a small example file. Please take a look at the "Print Layout" layout.

In there, I would like to see total customer. Manually, it would be counted as 3 customers, but how to do it in calculation?

Thank you for help and suggestion.

As usual, if this has been discussed before, please let me know the link and I can read and learn it.

Thank you.

Test.zip

See:

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

Hi Comment (Michael),

Thank you for your information. Is this working for two tables? I've tried several times but it didn't work as expected.

I've tried created 2 new fields on table "ItemPurchased":

cInverseCount (calculation) = 1 / GetSummary (sCount ; ItemName )

sCountCustomers (summary) = Total of cInverseCount

PS: sCount (summary) = count of ItemName

Did I miss something?

I've searched this one reciprocal and read this one http://forums.filemaker.com/posts/4f9909b2d0 but the sample file is on the same table. Can it be done on two table? if yes, how? Any help would be appreciated.

Thank you.

Have you read the thread to the end?

I think I get it thanks.

Well, the problem is I should do on fkCustomer instead of ItemName. That's the issue. But now it's fixed.