Eliminating Duplicate Rows in Summary Report with Counts
I am trying to figure out how to eliminate duplicate rows when producing a summary report in FileMaker Pro. See the attached image where I'm trying just get the total counts for each group.
I have tried used the Field | Hide Field option but then the whole column disappears along with the count. How can I view this so that there is only one line for each Race, Gender, Age Group combination with the total count?