Average calcs

[chrishunt007]

Hi there, ive got 4 dimensions to my dataset e.g. below

Apples Pears Oranges 2017 2018 2017 2018 2017 2018 Manchester % people browse 50% 52% 40% 42% 35% 38% % people purchase 26% 30% 22% 21% 31% 33% London % people browse 45% 49% 33% 38% 32% 34% % people purchase 24% 20% 21% 18% 27% 30% Edinburgh % people browse 47% 51% 35% 40% 34% 36% % people purchase 26% 22% 23% 20% 29% 32% <colgroup><col><col><col span="2"><col><col span="3"></colgroup><tbody> </tbody>

<tbody>
</tbody>

I have data for each month of the year and need to provide the average across the year as below:

Filter: Apple/Pear/Orange Analysis needed Manchester London Edinburgh 2017 2018 2017 2018 2017 2018 Average % people browse Average % people purchase <colgroup><col><col span="6"></colgroup><tbody> </tbody>

<tbody>
</tbody>

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