Merge two pivot tables

[Jimmypop]

Good day

I am trying to follow this explanation Merge Pivot ... I am at the moment trying the step by creating relationships between Tables... but get the following error message



Where does my issue exist? First column of data will always be the same (date range) the second is counted values where duplicates might exist.

 

[Jimmypop]

Table4 Data

Near Misses for month end.xlsx
	A	B
358	Row Labels	Count of Classification
359	2021	34
360	Oct	9
361	Nov	12
362	Dec	13
363	2022	128
364	Jan	7
365	Feb	12
366	Mar	10
367	Apr	16
368	May	11
369	Jun	6
370	Jul	13
371	Aug	10
372	Sep	20
373	Oct	23
374	Grand Total	162
Charts & Summary KSA

Table6 Data

Near Misses for month end.xlsx
	A	B
185	Row Labels	Count of Classification
186	2021	141
187	Oct	37
188	Nov	79
189	Dec	25
190	2022	888
191	Jan	93
192	Feb	97
193	Mar	94
194	Apr	89
195	May	106
196	Jun	91
197	Jul	65
198	Aug	81
199	Sep	78
200	Oct	94
201	Grand Total	1029
Charts & Summary Reman