AnsweredAssumed Answered

Eliminating Duplicate Rows in Summary Report with Counts

Question asked by Larry_2 on Nov 20, 2012
Latest reply on Nov 21, 2012 by philmodjunk

Title

Eliminating Duplicate Rows in Summary Report with Counts

Post

     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?

     Thanks

FileMakerProSummaryExample.jpg

Outcomes