Pivot table options

[melbin]

Hi... Attached is a pivot table data. I dont know how to add 'change' columns as in this pivot table. change columns are used to compare the sales of a particular week with previous week.I checked the Pivot table fields and change is not there.

Year	2017
Month	(Multiple Items)
Week	(All)
	Column Labels
	Microsoft		Nokia		UberEats		Square 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>

 

[mart37]

add sales to values
use fieldsettings
use show as
use % different with
use previous