Pivot Table

[melbin]

Hi...

Attached below is a pivot table and i don't know how to add 'change' columns as in the attached pivot. I want to create a similar kind of pivot table.

The change columns are in percentage and it is used to compare the sales.

Year	2017
Month	(Multiple Items)
Week	(All)
	Column Labels
	Microsoft		Nokia		UberEats		POS		Epsilon		Sabre		Solana		Total Sales	Total change
Row Labels	Sales	change	Sales	change	Sales	change	Sales	change	Sales	change	Sales	change	Sales	change
9/3/2017	$495	100%	$128	100%	$177	100%	$8,241	100%	$307	100%	$691	100%	$436	100%	$10,475	100%
9/10/2017	$322	65%	$45	35%	$357	201%	$6,656	81%	$312	102%	$793	115%	$488	112%	$8,973	86%
9/17/2017	$312	97%	$31	69%	$291	81%	$6,720	101%	$326	104%	$656	83%	$374	77%	$8,708	97%
9/24/2017	$392	125%	$63	203%	$185	64%	$8,252	123%	$351	108%	$973	148%	$551	148%	$10,767	124%
10/1/2017	$366	94%	$31	49%	$251	135%	$6,234	76%	$367	105%	$873	90%	$483	88%	$8,605	80%
10/8/2017	$540	147%	$16	52%	$138	55%	$6,697	107%	$376	102%	$1,030	118%	$425	88%	$9,223	107%
10/15/2017	$551	102%	$41	256%	$198	143%	$6,865	103%	$379	101%	$1,889	183%	$723	170%	$10,644	115%
10/22/2017	$572	104%	$69	168%	$180	91%	$4,170	61%					$555	77%	$5,546	52%
Grand Total	$3,550		$423		$1,777		$53,834		$2,417		$6,905		$4,035		$72,941

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col span="3"><col><col></colgroup><tbody>
</tbody>