Variation Analysis in Pivot Table

F

fotao

New Member
Joined
Jul 8, 2015
Messages
1
Hi everyone,

I have seen explanations regarding how to present variations on Pivot Table, but none using some many fields as I need.

This is the information that I have:

[TABLE="width: 1142"]
<tbody>[TR]
[TD]Restaurant[/TD]
[TD]Year[/TD]
[TD]Month[/TD]
[TD]Date[/TD]
[TD]N.º Persons Lunch[/TD]
[TD]Sales Lunch[/TD]
[TD]Average sale lunch[/TD]
[TD]N.º Persons Dinner[/TD]
[TD]Sales Dinner[/TD]
[TD]Average sale Dinner[/TD]
[TD]N.º Persons All Day[/TD]
[TD]Sales All Day[/TD]
[TD]Average sale All Day[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]01/01/2014[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1250[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]02/01/2014[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1320[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2450[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3770[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]03/01/2014[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]1378[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]2560[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]3938[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]04/01/2014[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]1377[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]2340[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]3717[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]05/01/2014[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]1352[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]2405[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]3757[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]1560[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]2496[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]4056[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]02/01/2015[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]1624[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]2516[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]4140[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]03/01/2015[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]2376[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]134[/TD]
[TD="align: right"]3926[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]04/01/2015[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]1458[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]3558[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]05/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1320[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]2448[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]3768[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]02/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]03/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]04/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]AA[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]05/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]01/01/2014[/TD]
[TD="align: right"]60[/TD]
[TD="align: right"]1560[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]2496[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]138[/TD]
[TD="align: right"]4056[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]02/01/2014[/TD]
[TD="align: right"]58[/TD]
[TD="align: right"]1624[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]74[/TD]
[TD="align: right"]2516[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]132[/TD]
[TD="align: right"]4140[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]03/01/2014[/TD]
[TD="align: right"]62[/TD]
[TD="align: right"]1550[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]72[/TD]
[TD="align: right"]2376[/TD]
[TD="align: right"]33[/TD]
[TD="align: right"]134[/TD]
[TD="align: right"]3926[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]04/01/2014[/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]1458[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]3558[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2014[/TD]
[TD]January[/TD]
[TD="align: right"]05/01/2014[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1320[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]68[/TD]
[TD="align: right"]2448[/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]123[/TD]
[TD="align: right"]3768[/TD]
[TD="align: right"]31[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]1250[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]2250[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3500[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]02/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1320[/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2450[/TD]
[TD="align: right"]35[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3770[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]03/01/2015[/TD]
[TD="align: right"]53[/TD]
[TD="align: right"]1378[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]80[/TD]
[TD="align: right"]2560[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]133[/TD]
[TD="align: right"]3938[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]04/01/2015[/TD]
[TD="align: right"]51[/TD]
[TD="align: right"]1377[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]78[/TD]
[TD="align: right"]2340[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]129[/TD]
[TD="align: right"]3717[/TD]
[TD="align: right"]29[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]2015[/TD]
[TD]January[/TD]
[TD="align: right"]05/01/2015[/TD]
[TD="align: right"]52[/TD]
[TD="align: right"]1352[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]65[/TD]
[TD="align: right"]2405[/TD]
[TD="align: right"]37[/TD]
[TD="align: right"]117[/TD]
[TD="align: right"]3757[/TD]
[TD="align: right"]32[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]01/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]02/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]03/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]04/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
[TR]
[TD]BB[/TD]
[TD]Budget 2015[/TD]
[TD]January[/TD]
[TD="align: right"]05/01/2015[/TD]
[TD="align: right"]55[/TD]
[TD="align: right"]1375[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]70[/TD]
[TD="align: right"]2100[/TD]
[TD="align: right"]30[/TD]
[TD="align: right"]125[/TD]
[TD="align: right"]3475[/TD]
[TD="align: right"]28[/TD]
[/TR]
</tbody>[/TABLE]



This is the Pivot Table that I can create:

[TABLE="width: 831"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Year[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Month[/TD]
[TD]Restaurant[/TD]
[TD]Valores[/TD]
[TD="align: right"]2014[/TD]
[TD="align: right"]2015[/TD]
[TD]Budget 2015[/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD]AA[/TD]
[TD]Sum of N.º Persons Lunch[/TD]
[TD="align: right"]261[/TD]
[TD="align: right"]289[/TD]
[TD="align: right"]275[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sum of Sales Lunch[/TD]
[TD="align: right"]6677[/TD]
[TD="align: right"]7512[/TD]
[TD="align: right"]6875[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Average ofAverage sale lunch[/TD]
[TD="align: right"]25,6[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sum of N.º Persons Dinner[/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]367[/TD]
[TD="align: right"]350[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sum of Sales Dinner[/TD]
[TD="align: right"]12005[/TD]
[TD="align: right"]11936[/TD]
[TD="align: right"]10500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Average ofAverage sale Dinner[/TD]
[TD="align: right"]32,8[/TD]
[TD="align: right"]32,6[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BB[/TD]
[TD]Sum of N.º Persons Lunch[/TD]
[TD="align: right"]289[/TD]
[TD="align: right"]261[/TD]
[TD="align: right"]275[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sum of Sales Lunch[/TD]
[TD="align: right"]7512[/TD]
[TD="align: right"]6677[/TD]
[TD="align: right"]6875[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Average ofAverage sale lunch[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]25,6[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sum of N.º Persons Dinner[/TD]
[TD="align: right"]367[/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]350[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Sum of Sales Dinner[/TD]
[TD="align: right"]11936[/TD]
[TD="align: right"]12005[/TD]
[TD="align: right"]10500[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Average ofAverage sale Dinner[/TD]
[TD="align: right"]32,6[/TD]
[TD="align: right"]32,8[/TD]
[TD="align: right"]30[/TD]
[/TR]
[TR]
[TD]Total Sum ofN.º Persons Lunch[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[/TR]
[TR]
[TD]Total Sum ofSales Lunch[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14189[/TD]
[TD="align: right"]14189[/TD]
[TD="align: right"]13750[/TD]
[/TR]
[TR]
[TD]Total Average ofAverage sale lunch[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25,8[/TD]
[TD="align: right"]25,8[/TD]
[TD="align: right"]25[/TD]
[/TR]
[TR]
[TD]Total Sum ofN.º Persons Dinner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]735[/TD]
[TD="align: right"]735[/TD]
[TD="align: right"]700[/TD]
[/TR]
[TR]
[TD]Total Sum ofSales Dinner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23941[/TD]
[TD="align: right"]23941[/TD]
[TD="align: right"]21000[/TD]
[/TR]
[TR]
[TD]Total Average ofAverage sale Dinner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]32,7[/TD]
[TD="align: right"]32,7[/TD]
[TD="align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]


And this is the analysis that I want, with the variations inside the pivot table so that I can see by restaurant, month lunch or dinner.

[TABLE="width: 1339"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Year[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Month[/TD]
[TD]Restaurant[/TD]
[TD]Valores[/TD]
[TD="align: right"]2014[/TD]
[TD="align: right"]2015[/TD]
[TD]Budget 2015[/TD]
[TD]Var. 2015/2014[/TD]
[TD]Var%. 2015/2014[/TD]
[TD]Var. 2015/Budget 2015[/TD]
[TD]Var. % 2015/Budget 2015[/TD]
[/TR]
[TR]
[TD]January[/TD]
[TD]AA[/TD]
[TD]Soma de N.º Persons Lunch[/TD]
[TD="align: right"]261[/TD]
[TD="align: right"]289[/TD]
[TD="align: right"]275[/TD]
[TD]28[/TD]
[TD]11%[/TD]
[TD]14[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Soma de Sales Lunch[/TD]
[TD="align: right"]6677[/TD]
[TD="align: right"]7512[/TD]
[TD="align: right"]6875[/TD]
[TD]835[/TD]
[TD]13%[/TD]
[TD]637[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Média de Average sale lunch[/TD]
[TD="align: right"]25,6[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]25[/TD]
[TD]0,4[/TD]
[TD]2%[/TD]
[TD]1[/TD]
[TD]4%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Soma de N.º Persons Dinner[/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]367[/TD]
[TD="align: right"]350[/TD]
[TD]-1[/TD]
[TD]0%[/TD]
[TD]17[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Soma de Sales Dinner[/TD]
[TD="align: right"]12005[/TD]
[TD="align: right"]11936[/TD]
[TD="align: right"]10500[/TD]
[TD]-69[/TD]
[TD]-1%[/TD]
[TD]1436[/TD]
[TD]14%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Média de Average sale Dinner[/TD]
[TD="align: right"]32,8[/TD]
[TD="align: right"]32,6[/TD]
[TD="align: right"]30[/TD]
[TD]-0,2[/TD]
[TD]-1%[/TD]
[TD]2,6[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]BB[/TD]
[TD]Soma de N.º Persons Lunch[/TD]
[TD="align: right"]289[/TD]
[TD="align: right"]261[/TD]
[TD="align: right"]275[/TD]
[TD]-28[/TD]
[TD]-10%[/TD]
[TD]-14[/TD]
[TD]-5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Soma de Sales Lunch[/TD]
[TD="align: right"]7512[/TD]
[TD="align: right"]6677[/TD]
[TD="align: right"]6875[/TD]
[TD]-835[/TD]
[TD]-11%[/TD]
[TD]-198[/TD]
[TD]-3%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Média de Average sale lunch[/TD]
[TD="align: right"]26[/TD]
[TD="align: right"]25,6[/TD]
[TD="align: right"]25[/TD]
[TD]-0,4[/TD]
[TD]-2%[/TD]
[TD]0,6[/TD]
[TD]2%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Soma de N.º Persons Dinner[/TD]
[TD="align: right"]367[/TD]
[TD="align: right"]368[/TD]
[TD="align: right"]350[/TD]
[TD]1[/TD]
[TD]0%[/TD]
[TD]18[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Soma de Sales Dinner[/TD]
[TD="align: right"]11936[/TD]
[TD="align: right"]12005[/TD]
[TD="align: right"]10500[/TD]
[TD]69[/TD]
[TD]1%[/TD]
[TD]1505[/TD]
[TD]14%[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Média de Average sale Dinner[/TD]
[TD="align: right"]32,6[/TD]
[TD="align: right"]32,8[/TD]
[TD="align: right"]30[/TD]
[TD]0,2[/TD]
[TD]1%[/TD]
[TD]2,8[/TD]
[TD]9%[/TD]
[/TR]
[TR]
[TD]Total Soma de N.º Persons Lunch[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD="align: right"]550[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[/TR]
[TR]
[TD]Total Soma de Sales Lunch[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]14189[/TD]
[TD="align: right"]14189[/TD]
[TD="align: right"]13750[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]439[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]Total Média de Average sale lunch[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]25,8[/TD]
[TD="align: right"]25,8[/TD]
[TD="align: right"]25[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]0,8[/TD]
[TD]3%[/TD]
[/TR]
[TR]
[TD]Total Soma de N.º Persons Dinner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]735[/TD]
[TD="align: right"]735[/TD]
[TD="align: right"]700[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]35[/TD]
[TD]5%[/TD]
[/TR]
[TR]
[TD]Total Soma de Sales Dinner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23941[/TD]
[TD="align: right"]23941[/TD]
[TD="align: right"]21000[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]2941[/TD]
[TD]14%[/TD]
[/TR]
[TR]
[TD]Total Média de Average sale Dinner[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]32,7[/TD]
[TD="align: right"]32,7[/TD]
[TD="align: right"]30[/TD]
[TD]0[/TD]
[TD]0%[/TD]
[TD]2,7[/TD]
[TD]9%[/TD]
[/TR]
</tbody>[/TABLE]


Any ideias?
Take into consideration that I can't change the format of the original data.


Thanks,
Fotao
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
You must log in or register to reply here.

Similar threads

L
  • Question Question
Formula Help with Count Number of Vessel Turnaround Trips monthly based on Criteria
Replies
1
Views
455
Lukma
L
H
  • Solved
Creation of arrows for 2 family trees.
Replies
8
Views
368
harzer
H
A
  • Question Question
create report for 40000 rows to calculation stock across sheet based on sheet name in cell value
Replies
1
Views
349
Amer Omar
A
A
  • Solved
Replace formula with zero when populate Right mark for two sheets
Replies
3
Views
367
awoohaw
awoohaw
F
  • Question Question
Graph Help
Replies
2
Views
306
Fegal
F

Forum statistics

Threads
1,223,911
Messages
6,175,323
Members
452,635
Latest member
laura12345

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top