How to tally new registrants beside Participants list

[MageVortex]

Hello,

I'm trying to get the number of new registrants totalled beside the count of those who participated in a scheduled recurring meeting. Below is a picture of how it comes out with the data as is, and there are many times where people registered to join the meetings a few days or a week or so, but my goal is for all of those who registered to show up as a tallied total from the time of the last meeting to that days meeting rather than 0 values for 'Participants' showing beside the sporadic Registrants. The data it is built off of is included below. Suggestions for best method?

Start of WeekRegistrationsParticipantsDate

9/10/2023	10	81	9/13/2023
8/27/2023	1	0	8/29/2023
8/20/2023	15	108	8/23/2023
8/20/2023	5	0	8/22/2023
8/13/2023	1	0	8/17/2023
8/6/2023	1	0	8/7/2023
8/6/2023	28	101	8/9/2023
8/6/2023	1	0	8/12/2023
8/6/2023	1	0	8/8/2023
7/23/2023	6	102	7/26/2023
7/16/2023	1	0	7/18/2023
7/9/2023	4	0	7/12/2023
7/9/2023	1	0	7/11/2023
7/9/2023	1	0	7/10/2023
7/2/2023	1	0	7/6/2023
6/25/2023	3	84	6/28/2023
6/25/2023	1	0	6/26/2023
6/4/2023	1	0	6/8/2023
6/4/2023	13	90	6/7/2023
5/28/2023	1	0	6/1/2023
5/28/2023	2	0	6/2/2023
5/21/2023	1	0	5/23/2023
5/14/2023	12	79	5/17/2023
5/14/2023	1	0	5/19/2023
5/14/2023	1	0	5/18/2023
4/30/2023	11	91	5/3/2023
4/30/2023	1	0	5/2/2023
4/16/2023	1	0	4/20/2023
4/16/2023	22	95	4/19/2023
4/16/2023	1	0	4/18/2023
4/9/2023	1	0	4/14/2023
4/9/2023	4	0	4/11/2023
4/2/2023	11	95	4/5/2023
4/2/2023	2	0	4/4/2023
3/26/2023	2	0	3/31/2023
3/26/2023	1	0	3/28/2023
3/26/2023	1	0	3/27/2023
3/19/2023	1	0	3/23/2023
3/19/2023	22	92	3/22/2023
3/12/2023	3	0	3/14/2023
3/12/2023	3	0	3/15/2023
3/12/2023	1	0	3/13/2023
3/5/2023	21	93	3/8/2023
2/26/2023	2	0	3/1/2023
2/26/2023	2	0	2/27/2023
2/26/2023	3	0	2/28/2023
2/19/2023	2	0	2/24/2023
2/19/2023	6	66	2/22/2023
2/19/2023	4	0	2/23/2023
2/19/2023	1	0	2/25/2023
2/19/2023	13	0	2/21/2023
2/12/2023	1	0	2/17/2023
2/5/2023	4	67	2/8/2023
2/5/2023	1	0	2/11/2023
2/5/2023	11	0	2/7/2023
1/29/2023	4	0	2/1/2023
1/29/2023	4	0	1/30/2023
1/29/2023	1	0	2/3/2023
1/29/2023	4	0	1/31/2023
1/22/2023	17	71	1/25/2023
1/22/2023	1	0	1/26/2023
1/22/2023	5	0	1/27/2023
1/22/2023	1	0	1/23/2023
1/22/2023	2	0	1/24/2023
1/15/2023	1	0	1/20/2023
1/15/2023	2	0	1/19/2023
1/15/2023	2	0	1/18/2023
1/8/2023	40	69	1/11/2023
1/8/2023	2	0	1/13/2023
1/8/2023	4	0	1/9/2023
1/8/2023	1	0	1/8/2023
1/8/2023	5	0	1/10/2023
1/1/2023	2	0	1/7/2023
1/1/2023	2	0	1/4/2023
1/1/2023	18	0	1/6/2023
1/1/2023	51	0	1/5/2023

[lbendlin]

Like this?

[MageVortex]

Not quite - I want to tally the number of new registrants between meetings.  So if between 1/11/23 and 1/25/24 is 50 new people, w/ 69 who attend, then I'd want it to show 50/69 respectively.
If then between the 4/5 and 4/19 meeting, we had 12 newly registered and 95 attend, those are the numbers I'd want the chart to provide for the 4/19 meeting.  So the difference in registered between the prior event and the present event (prior event being 4/5 and present being 4/19 in this instance).

Does that make sense?

[lbendlin · Accepted solution]

see attached

[MageVortex]

That did it, thank you kindly good sir!