Average calcs

[chrishunt007]

Hi there, ive got 4 dimensions to my dataset e.g. below
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 602"]
<colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]Apples[/TD]
[TD] [/TD]
[TD]Pears[/TD]
[TD] [/TD]
[TD]Oranges[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]2017[/TD]
[TD]2018[/TD]
[TD]2017[/TD]
[TD]2018[/TD]
[TD]2017[/TD]
[TD]2018[/TD]
[/TR]
[TR]
[TD]Manchester[/TD]
[TD]% people browse[/TD]
[TD]50%[/TD]
[TD]52%[/TD]
[TD]40%[/TD]
[TD]42%[/TD]
[TD]35%[/TD]
[TD]38%[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]% people purchase[/TD]
[TD]26%[/TD]
[TD]30%[/TD]
[TD]22%[/TD]
[TD]21%[/TD]
[TD]31%[/TD]
[TD]33%[/TD]
[/TR]
[TR]
[TD]London[/TD]
[TD]% people browse[/TD]
[TD]45%[/TD]
[TD]49%[/TD]
[TD]33%[/TD]
[TD]38%[/TD]
[TD]32%[/TD]
[TD]34%[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]% people purchase[/TD]
[TD]24%[/TD]
[TD]20%[/TD]
[TD]21%[/TD]
[TD]18%[/TD]
[TD]27%[/TD]
[TD]30%[/TD]
[/TR]
[TR]
[TD]Edinburgh[/TD]
[TD]% people browse[/TD]
[TD]47%[/TD]
[TD]51%[/TD]
[TD]35%[/TD]
[TD]40%[/TD]
[TD]34%[/TD]
[TD]36%[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]% people purchase[/TD]
[TD]26%[/TD]
[TD]22%[/TD]
[TD]23%[/TD]
[TD]20%[/TD]
[TD]29%[/TD]
[TD]32%[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I have data for each month of the year and need to provide the average across the year as below:
[TABLE="width: 500"]
<tbody>[TR]
[TD][TABLE="width: 528"]
<colgroup><col><col span="6"></colgroup><tbody>[TR]
[TD]Filter: [/TD]
[TD="colspan: 2"]Apple/Pear/Orange[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Analysis needed[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Manchester[/TD]
[TD] [/TD]
[TD]London[/TD]
[TD] [/TD]
[TD]Edinburgh[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]2017[/TD]
[TD]2018[/TD]
[TD]2017[/TD]
[TD]2018[/TD]
[TD]2017[/TD]
[TD]2018[/TD]
[/TR]
[TR]
[TD]Average % people browse[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Average % people purchase[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I am having difficulty with the pivot table as it is not picking up each row when I pivot. And averageifs is proving to be tricky. Does anyone have ideas? Thanks