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