I have a simple table to record authors of books. For each author (~1000) I will record the sex (male, female, other, etc). I want to produce a report to show progress on filling in all those values. So I want to show the % of male, female, other, and not set. I can't see a way to bucket the blank/null/not set values in to a group that can be counted. Is that possible?
Thanks in advance..