AnsweredAssumed Answered

Summarizing demographics

Question asked by JohnD6547 on Oct 10, 2014
Latest reply on Oct 11, 2014 by philmodjunk


Summarizing demographics


I'm new to FileMaker, so please bear with what seems like it should be a simple question.  I have a table of people that includes information fields like age, gender (designated by M or F), ethnicity etc.  In addition, each person belongs to one of 6 groups, identified in a field named Group by a number from 1 to 6.

I'd like to generate a layout that summarizes the demographics of this collection, first for all members and then by group, including pie charts that show gender and ethnicity breakdowns.  However, I can't figure out how to get the charts to behave.  I have my table sorted by group, but when I try to create a gender or ethnicity pie chart in a subsummary report, I get a single slice for each member of the group.  I must be missing something obvious, but I can't figure out what it is.