We are a mental healthcare organization and I have a report that has multiple levels of groups.
Cost Center
-
Program
-
Service Code
-
Service Code
-
Patient ID
For our Residential Program, only, I need to divide the service codes into Education, Room-Board, and Mental Health Services. Then, for all of our treatment programs, including Residential, I need to individually sum the total revenue for each service code. The only way I have been able to do that, is to have two levels of grouping for the Service codes. The first level breaks them into the Educ, R-B and MHS groups, while the second Service Codes group displays them individually. Then group each service code by Patient ID. So far so good.
However, it appears that the report is actually grouping by Service Code, then Patient ID, then by Service Code. The result is that the report is displaying individual service codes multiple times, when it should just be displayed once for each program.
Any ideas???