Comparing a Stats from a Table with dates needed to Filter

[Johnce1607]

Good Morning, 

So I have a table with the Schema as follows;

Added Date	Bookings Date	Total Price	Week No
01/01/2022	05/06/2023	100	LAST YEAR
01/01/2023	01/05/2023	200	1
08/01/2023	01/04/2023	50	2

So I need to look at this week by week

Week 1 i need to return 

Total Bookings	Added This Week	Increase %
300 (Row 1 & 2) (Needs to include ALL bookings with a bookings date of 2023 but only up to Added date of the week in question	£200 (Row 2)	200%  Total Price for all bookings with bookings date added up to W1 / Total Price for all booking with bookings date added date up to Last week

Week 2 

Total Bookings	Added this week	Increase %
£350	£50	50/(350-50) = 16.66%

I hope this makes sense, Its difficult due to the mutliple dates required, i cant get this to work with the calendar, as i need to be able to use the calendar weeks to present a dashboard.

[lbendlin]

Wouldn't week 1 be a 100% increase?

i cant get this to work with the calendar, as i need to be able to use the calendar weeks to present a dashboard.

how is that preventing you from using a calendar?