Metric parameter on group of columns

Have the following user case:

Fighting to Diabetes Program, is a program that have the objective to provide medical services to patient with Diabetes, where patient decides to be enrolled or disenrolled (after enrollment) on the program.

Program Owners want to know if program is successful or not. The methodology is comparison the AC1 results, Unexpected Events (#events), Inpatient visits(#visits), Transportation (#services and #miles), Food ($cost and #shopping), and 15 concept/metrics more. With a lookback period like 6 Prior enrollment months, Enrollment months, and 6 Post enrollment months, using a matrix per Aspect to measure.

The dashboard should have parameter/slicer with each enrollment status (Enrolled and Disenrolled).

• If user select Disenrolled, the matrix should show comparison Prior vs During enrollment, During vs Post enrollment, and Prior vs Post enrollment metrics (AV1 result and % Var)
• If user select Enrolled, the matrix should show comparison Prior vs During enrollment metrics (AV1 result and % Var), because all comparison vs Post enrollment is not happening because patient is already enrolled.

This functionality will minimize the development time due to many matrices per concept/metrics to be created.

Crossing finger, you can develop functionality for us.