Managing University Funnel Data

[DinaFlo]

I'm having a hard time working with enrollment funnel data, which gives a week-by-week total of:
Applications Started

Applications Submitted

Accepted

Enrolled

Registered

Basically, my weekly values are already aggregated.

So I don't want to sum the data together in many cases, but I want to be able to look at the data week over week, organized by program and application term.  I might want to add total App Starts per Program, or total App Starts per Term (I actually just created a Max table for this, with the most recent values for each program and term combination), but I don't want to add week-by-week App Starts. 

I also want to compare the current week to the last week (6/19 compared to 6/12).  I have a Calendar table to manage my current and prior week.  I'm just having trouble pulling that row or set of rows.

Here's a sample of the kind of data I'm looking at.  Any help or direction is appreciated!

Date	Program	Entry Term	App Starts	Submits	Accept	Enrolled	Registered
6/5/23	MBA	Fall 2023	165	59	42	38	12
6/12/23	MBA	Fall 2023	172	61	43	38	15
6/19/23	MBA	Fall 2023	175	65	43	40	27
6/5/23	MBA	Spring 2024	37	2	0	0	0
6/12/23	MBA	Spring 2024	51	4	1	0	0
6/19/23	MBA	Spring 2024	62	7	2	1	0
6/5/23	MSIS	Fall 2023	201	71	42	35	23
6/12/23	MSIS	Fall 2023	212	78	44	39	31
6/19/23	MSIS	Fall 2023	212	79	45	39	35
6/12/23	MSIS	Spring 2024	21	5	0	0	0
6/19/23	MSIS	Spring 2024	33	8	2	1	0