Chart how-to: Count of factor 1 vs. factor 2?
I'm new to Filemaker, and am still trying to figure out how its charting system works. I've got a database that contains, among other things, columns for "age" and "household income". Each row has a value for these columns, like so:
- Age: One of "18-24", "25-34", "35-50", and so on.
- Household income: One of "less than $25,000", "$25,000 - $35,000", and so on.
I'm trying to get a graph containing sets of columns that show the number of people in each cell of the table, if you will:
- For age = 18-24, the numbers of people in each of the income groups
- For age = 25-34, the numbers of people in each of the income groups,
- and so on
Pretty straightforward, but I just can't figure it out. I'm guessing it has something to do with creating leading or trailing groups, but, again, I'm just not there. Can anybody offer some advice? Thanks!