I am not sure if this question has been asked before but i have a table with 4 columns, Trip Name, Fee, Booked Date and Closing date.

Trip Name and Fee are quite obvious. Booked date is the date the trip is booked and closing month is the the time when the Trip File is closed (as in after the trip is completed). So what i am trying to achieve here is  Total Fee for a specific Closing date this Financial Year booked until today (or any other specific day)

So for example if the closing date is June (month view that is), what is the Total Fee for this financial year that have been booked until today?

In essence like today 25/9/18 (closing date) what is the total fee for anything in the fiscal year booked up to now as compared to anything booked in the FY last year until 25/9/17. Hope this makes sense