ayescas

sub-summary report help

Discussion created by ayescas on Jul 7, 2018
Latest reply on Jul 7, 2018 by philmodjunk

Hello Group,

I have no idea how to approach the following:

 

I have a file with student records used in a sub-summary report.  The sub-summary report uses the school's name for the break field. 

 

Here is a sample:

ID 1; John Doe; school A

ID 2; John Doe; school A

ID 3; John Doe; school A

ID 4; John Doe; school A

ID 5; John Doe; school B;

 

The sub-summary will show John Doe, twice because he appears in School A and B. 

 

School B is the most recent school he attends.  I still need the sub-summary to calculate all records for John Doe but show the most recent school only.

 

Here is a sample for the desired sub-summary:

School B

John Doe; Record count 5

 

Thank you...

Outcomes