Hi
I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference also. I need to this for 14 stores. Can anybody point me in the right direction or advise if i have the table in the right format to be able to create pivot required.
I have sample data below of the way I have it set up
<tbody>
</tbody>
Ideally would like data to display like the below. Any help greatly appreciated
<colgroup><col><col span="3"><col></colgroup><tbody>
</tbody>
<colgroup><col><col span="3"><col></colgroup><tbody>
</tbody>
Many Thanks
Sinead
I need some help setting up a pivot table. I need to compare sales figures from 2 seperate years for example sales figures from week 1 2016 against sales figures for week 1 2017 for each store. I then need to be able to show the monetary difference between each year and the % difference also. I need to this for 14 stores. Can anybody point me in the right direction or advise if i have the table in the right format to be able to create pivot required.
I have sample data below of the way I have it set up
<tbody> </tbody> |
<tbody>
</tbody>
Ideally would like data to display like the below. Any help greatly appreciated
<colgroup><col><col span="3"><col></colgroup><tbody>
</tbody>
2016 | 2017 | Variance | % Variance | |
Sales Value | 500 | 100 | -400 | -80% |
Sales Returns | 200 | 100 | -100 | -50% |
<colgroup><col><col span="3"><col></colgroup><tbody>
</tbody>
Many Thanks
Sinead
Last edited: