Dates pre and post selection

Hi, 

I need so help with dates please.

I have 4 different dates coming from my app_event table. These dates are app_event_date: 

01/11/2023

15/11/2023

06/12/2023

18/12/2023

I then have another table app_in which tracks the app_value and id (for a count) of an application. The date used is called app_in_date.

I use app_in_date on my filter as I only want to see the app_value since the very first app_event_date I.e app_in_date greater than 01/11/2023.

During the four events app_event_date there could be 1 applicant that attended 2 out of the 4 events. 

As it stands, if app_name attended 01/11/2023 and 18/12/2023 then I need to see how many (count id) and how much (app_value) there has been post event.

Example:

App_name attended app_event date 01/11/2023 and submitted 2 apps post event for a total of £500. 

App_name also attended app_event_date 18/12/2023 and submitted 1 app for £100, post event. 

If I select the filter (app_event_date) as the 18/12/2023, my card value show 3 apps (count id) and my other shows £600 (app_value).

However, what I want is, if I select 01/11/2023, I want app_name cards to show as 3 apps (count id) and £600 (app_value) as these values are post 01/11/2023.

If I select 18/12/2023, I want my cards to show 1 app (count id) and £100 (app_value) as that's happened post that filtered app_event_date. 

I hope this makes sense. Essentially, I want to see only the outcomes post event and not pre event. 

Is this possible please?