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.