Frequency Counts (Revisited?)
I've reviewed a few posts regarding this topic and still can't seem to get a report of the frequency of occurances in my DB. I maintain a large DB of requests for certain restricted drugs. We receive about 2000/month. At the end of the year, I would like to rank the requested agents by frequencty of request.
So I'd like FMP to provide a table of with drug name (fieldname is DrugID) and number of records for each drug listed in the defined date range (usually FY). So the report would have to recognize the unique entries in the DrugID field (it is free text) and sort in declining order of frequency.
Any help would be greatly appreciated. Thanks!