I still don't know what constitutes SLM or PIF. You said this is based on the funding officer. Why can't you run the report based on a calculation based upon the funding officer. That is, the funding officer probably comes from a table along with the SLM or PIF status. Correct? You can then use this information in the summary report.
SLM and PIF constitutes how the students are funded, those are shortcut for: pay in full and sallie mae. I am using the funding officer to do my summary report to the break down the enrollment status. Now i need to figure out how to get the funding status base on the enrollment status for each funding officer. let say i have funding officer james smith, how the 50 he has enrolled. how many are SLM and PIF. i am able to get all the total for the enrollment statuses but not for each individual one.
If you have the 50 enrolled, you should have the status of those 50. For simplistic case, 25 SLM and 25 PIF. In your sub-summary by students, where you show how many are enrolled, you can add an additional sub-summary when sorted by status to break it down even further. That is: