Another Bar Chart / Calculation question
Using Filemaker 11 with OSX10.6 SL on my Macbook Pro.
I have one table with Customer ID'# in one field and Customer State in another. I would like to make a bar chart with Customer State on the x-axis and number of customer's in each of these states on the y-axis. I am having trouble doing this. It would seem that I need some type of field with the total number of Customers in each state for the chart feature to access. Is this true? Any suggestions would be greatly appreciated. I am a fm charts noob.
You need a summary field defined as count of CustomerID (or any field that cannot be empty). Use this field as the Y-axis data (grouped). Records must be sorted by State.
Note that this assumes CustomerID is unique, at least within each state.