I wouldn't do this in a cross-tab. Instead, I would group by gender, create one formula so that you can count the active people and then use summaries to get your numbers.
The formula would have logic like this:
if {MyTable.Status} = 'Active' then {MyTable.PersonID}
Do a distinct count people per group and grand total people. Also do a distinct count of active people and the grand total active.
Put the grand totals in the report header and the group totals in the group header. Suppress all other sections.
-Dell
IP Logged
