Total up to the end of week matrix

[Ejykso]

Hi All,
I'll appreciate it if someone can help with a way to resolve this issue. 
I'm to present my data in this format:

Up to End of Week	19.2023			12.2.2023			Variance
Period	Vol	Net		Vol	Net		Vol	Net
1-7 Days	20	2000		10	1000		10	1000
8-14 Days	20	1000		10	2000		10	-1000
15-21 Days	10	4000		20	3000		-10	1000
21days +	55	3000		30	4000		25	-1000
Total	105	10000		70	10000		35	0

But my data came is showing as this:

End of Week	19.2.2023			12.2.2023			05.2.2023			29/01/2023	Total
Period	Vol	Net		Vol	Net		Vol	Net	Vol	Net	Vol	Net
1-7 Days	20	2000		10	1000						30	3000
8-14 Days				10	2000				20	1000	30	3000
15-21 Days							20	3000	10	4000	30	7000
21days +				30	4000		55	3000			85	7000
Total	105	10000		50	7000						175	20000

Basically, what I intend to achieve is to show the total Vol and Net up to the end of the week which table 1 is doing, and then compare it with the total up to the end of the previous week. 

My current method is splitting the data into different end of weekdays as seen in table 2 simply because of the end-of-week column that I'm using from my date table then showing the total at the end. I want this total which occurs at the end to be showing under 19:02:2023. My days period is calculated from the difference between the date of sale and today using a switch () so the longer the difference, the figures would start falling into different end of weeks days which I don't want.