Unanswered: Report to calculate totals on fields containing multiple entries
Hello. I hope someone can help me. I need to run a report based on data in one field, however, the user has the ability to select more than one, in this case, error type. When I categorisze by that field, I can only receive counts on exact replicas. The fields would look something like this:
I need to know how many "A"s there are, "B"s, and so on as opposed to 5 "A"s, 4 "AB"s. I know I can use the "*" in a query to get totals on each, however, there are too many options. If anyone can point me in a direction, it would be greatly appreciated!