Cumulative total by day and workload - how should I combine this in a table?

Hi guys,

Struggling to identify to best way to combine my data in a table and I`m hoping I can get some insight here.

As you can see in my document attached, I have daily breakdowns per week of hours worked (inbound = helpline, outbound) by a call centre.
I want to also include data such as how many calls and emails were done per person per day. What do you think would be the best layout here?

Thank you guys.

Your data analysis would be simpler if you had one column for the week number and one for the date.

Hi Ali,

Thank you for the prompt response. I`m not sure I quite follow.

Can you elaborate please?

Hopefully this illustrates what I mean:

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J	K
1			Helpline	Outbound
2	Week 1	01.01.2018	0	0		Totals cumulative for Week			Totals cumulative for Year
3	Week 1	02.01.2018	1	4			Helpdesk	Outbound		Helpdesk	Outbound
4	Week 1	03.01.2018	1	3.75		Week 1	3.25	22.25		3.25	22.25
5	Week 1	04.01.2018	0	0		Week 2	3	42.5		6.25	64.75
6	Week 1	05.01.2018	0	0.25
7	Week 1	06.01.2018	1.25	9.25
8	Week 1	07.01.2018	0	5
9	Week 2	08.01.2018	0.75	3.5
10	Week 2	09.01.2018	1	3.5
11	Week 2	10.01.2018	0	5
12	Week 2	11.01.2018	0	7.75
13	Week 2	12.01.2018	0.75	4.5
14	Week 2	13.01.2018	0.5	13.75
15	Week 2	14.01.2018	0	4.5

Sheet: Sheet1

Excel 2016 (Windows) 32 bit

	G	H	I	J	K
4	=SUMIF($A$2:$A$15,F4,$C$2:$C$15)	=SUMIF($A$2:$A$15,F4,$D$2:$D$15)		=SUM(G$4:G4)	=SUM(H$4:H4)

Sheet: Sheet1

Thanks for the rep and marking this thread as solved.