Pivot Table

[Sineadd]

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

Week No Date Store Sales Values Sales Returns 1 01/01/2016 Store 1 0 0 1 02/01/2016 Store 1 14556.35 12847.35 1 03/01/2016 Store 1 27535.6 13599.1 1 04/01/2016 Store 1 17773.3 9956.4 1 05/01/2016 Store 1 23932.68 16530.4 1 06/01/2016 Store 1 7260.6 5942.6 1 01/01/2017 Store 1 0 0 1 02/01/2017 Store 1 24477.8 20783.8 1 03/01/2017 Store 1 14059.9 11858.599 1 04/01/2017 Store 1 14200.69 14770.699 1 05/01/2017 Store 1 6198.5 7744.2 1 06/01/2017 Store 1 18234.68 15949.85 1 07/01/2017 Store 1 28103 17144 <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

 

[dbadash]

Re: Pivot Table Help!!

Pm'd

 

[Sineadd]

Re: Pivot Table Help!!

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

Week No Date Store Sales Values Sales Returns 1 01/01/2016 Store 1 0 0 1 02/01/2016 Store 1 14556.35 12847.35 1 03/01/2016 Store 1 27535.6 13599.1 1 04/01/2016 Store 1 17773.3 9956.4 1 05/01/2016 Store 1 23932.68 16530.4 1 06/01/2016 Store 1 7260.6 5942.6 1 01/01/2017 Store 1 0 0 1 02/01/2017 Store 1 24477.8 20783.8 1 03/01/2017 Store 1 14059.9 11858.599 1 04/01/2017 Store 1 14200.69 14770.699 1 05/01/2017 Store 1 6198.5 7744.2 1 06/01/2017 Store 1 18234.68 15949.85 1 07/01/2017 Store 1 28103 17144 <tbody> </tbody>

<tbody>
</tbody>

Ideally would like data to display like the below. Any help greatly appreciated

<tbody>
</tbody>

	2016	2017	Variance	% Variance
Sales Value	500	100	-400	-80%
Sales Returns	200	100	-100	-50%

<tbody>
</tbody>

Many Thanks
Sinead

So i have the below sorted but can anyone show me hoe to get the variance and % Variance

Store	Castlebar
Week No	(Multiple Items)
	Column Labels
Values	2018	2019	Variance	Variance %
Sum of Sales Values	68562.5	79189.43	147751.93
Sum of Sales Returns	59303.93	70908.86	130212.79

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

When I go to the field settings for the VAriance column and try to change the field settings to variance I am not sure what to choose to get the desired results


Any help appreceiated


Thanks
Sinead