I need a solution on how to get the correctly.
1. I am generating a report on total number of Arrests by gender.
2. The fields I have chosen are Case number, Date of Arrest, Name, Gender, and Offense. And grouped by Gender.
3. I am trying to get a total for how many total arrests there were for each Gender.
I can't do a distinct count by case number because sometimes there are multiple people arrested per case number. I can't do a distinct count on Name, because sometimes people are arrested more than once.
Looking for a solution to get the most accurate count of Arrests by gender.