creating pie charts from drop down menus
I am a complete newbe to FMP and databases - help! Getting on well with FMP but I need to create Pie and bar charts from data produced in drop down menus.
For example, I have a security business and want to see how many records are Intruder, cctv or fire systems in chart form but so far the charts I produce show all records as a percentage of all records available. (ie from 100 records - 30 intruder, 50 fire and 20 cctv systems are shown as individual 1% segments)
Can anyone tell me the next step?