My value list includes: X,1,2,3,4,5,6,7,8,9,10. I want to see each month how many of each value list item is selected.
How many values can be selected in a single record?
Just 1 per month. I think I may have found a calculation to make this work. I will do further testing tomorrow. Thanks. Faith
The "native" Filemaker would be to use a summary field to count the records, and sub-summarize the records by month and by value (or the otther way round) to get a report in the form of:
There is no built-in cross-tab feature, but severals methods have been proposed - see for example:
Wonderful! This is exactly what I ended up doing, so it is good to see this is how you also suggest to complete the summary. Thanks for the example file, I will review it. Faith