Create a report where "null" (or blank) is counted

Hello --

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..

Hello Bill,


This is possible by using a new table (parent table) only one row .. connected to each row of your table .


in that table you add 4 new field one for mail , one for female and one for other options.. 


and each field is count field (Count()) with where conditions 



Sunny Singla