0% found this document useful (0 votes)
80 views20 pages

Ptableexample End

The document contains monthly sales data for different products across multiple countries, including total revenue, variance, and budget figures. It shows that total variance was -4222 with total revenue of 1026278 against a budget of 1030500. Specific data is also shown for individual countries like France, Canada, and the US as well as for particular products in certain countries.

Uploaded by

Yogendra Bansal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
80 views20 pages

Ptableexample End

The document contains monthly sales data for different products across multiple countries, including total revenue, variance, and budget figures. It shows that total variance was -4222 with total revenue of 1026278 against a budget of 1030500. Specific data is also shown for individual countries like France, Canada, and the US as well as for particular products in certain countries.

Uploaded by

Yogendra Bansal
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Product - all -

Country - all -

Data
Month Sum - Var Sum - Revenue Sum - Budget
January -4297 8.53% 91831
February 2843 8.81% 87534
March -1389 8.67% 90377
April -2774 8.28% 87756
May -423 8.24% 84982
June -548 8.19% 84559
July 2366 8.42% 84011
August -2843 8.14% 86377
September 1389 8.27% 83534
October -4318 7.85% 84923
November 3406 8.19% 80605
December 2366 8.42% 84011
Total Result -4222 100.00% 1030500
Product - all -
Country - all -

Data
Sum - Var Sum - RevenSum - Budget Sum - Revenue
-4222 1026278 1030500 100.00%
Product - all -
Country Canada

Data
Month Sum - Var Sum - Revenue Sum - Budget Sum - Revenue
January 2929 32259 29330 9.79%
February 3318 35363 32045 10.73%
March -10733 24630 35363 7.48%
April 1054 20343 19289 6.17%
May 8332 28675 20343 8.70%
June -2823 28044 30867 8.51%
July -5114 22930 28044 6.96%
August -3855 23975 27830 7.28%
September -1654 22321 23975 6.78%
October 1454 29330 27876 8.90%
November 2929 32259 29330 9.79%
December 1454 29330 27876 8.90%
Total Result -2709 329459 332168 100.00%
Product - all -
Country France

Data
Month Sum - Var Sum - Revenue Sum - Budget Sum - Revenue
January -5772 27399 33171 7.43%
February -3846 29108 32954 7.89%
March 11529 32313 20784 8.76%
April -54 37600 37654 10.19%
May 3318 35363 32045 9.59%
June -3740 32855 36595 8.91%
July -275 27239 27514 7.38%
August 2769 33432 30663 9.06%
September -2983 29217 32200 7.92%
October -1917 27300 29217 7.40%
November 0 23876 23876 6.47%
December 912 33171 32259 8.99%
Total Result -59 368873 368932 100.00%
Product - all -
Country US

Data
Month Sum - Var Sum - Revenue Sum - Budget Sum - Revenue
January -1454 27876 29330 8.50%
February 3371 25906 22535 7.90%
March -2185 32045 34230 9.77%
April -3774 27039 30813 8.24%
May -12073 20521 32594 6.26%
June 6015 23112 17097 7.05%
July 7755 36208 28453 11.04%
August -1757 26127 27884 7.97%
September 6026 33385 27359 10.18%
October -3855 23975 27830 7.31%
November 477 27876 27399 8.50%
December 0 23876 23876 7.28%
Total Result -1454 327946 329400 100.00%
Product - all -
Country - all -

Data
Month Sum - Var Sum - Revenue Sum - Budget Sum - Revenue
January -4297 87534 91831 8.53%
February 2843 90377 87534 8.81%
March -1389 88988 90377 8.67%
April -2774 84982 87756 8.28%
May -423 84559 84982 8.24%
June -548 84011 84559 8.19%
July 2366 86377 84011 8.42%
August -2843 83534 86377 8.14%
September 1389 84923 83534 8.27%
October -4318 80605 84923 7.85%
November 3406 84011 80605 8.19%
December 2366 86377 84011 8.42%
Total Result -4222 1026278 1030500 100.00%
Product Chip 3
Country France

Data
Month Sum - Var Sum - Revenue Sum - Budget Sum - Revenue
March 11529 32313 20784 25.33%
June -3740 32855 36595 25.76%
September -2983 29217 32200 22.91%
December 912 33171 32259 26.01%
Total Result 5718 127556 121838 100.00%
Product - all -
Country France This shape represents a
slicer. Slicers are
Data supported in Excel 2010
Month Sum - Var Sum - Revenue Sum - Budget Sum - Revenue or later.
January -5772 27399 33171 7.43%
If the shape was modified
February -3846 29108 32954 7.89% in an earlier version of
March 11529 32313 20784 8.76% Excel, or if the workbook
April -54 37600 37654 10.19% This shape in
was saved represents a
Excel 2003
slicer. Slicers are
or earlier, the slicer cannot
May 3318 35363 32045 9.59%
supported
be used. in Excel 2010 or
June -3740 32855 36595 8.91% later.
July -275 27239 27514 7.38%
August 2769 33432 30663 9.06% If the shape was modified
September -2983 29217 32200 7.92% in an earlier version of
October -1917 27300 29217 7.40% Excel, or if the workbook
was saved in Excel 2003
November 0 23876 23876 6.47% or earlier, the slicer cannot
December 912 33171 32259 8.99% be used.
Total Result -59 368873 368932 100.00%
pe represents a
icers are
d in Excel 2010

ape was modified


lier version of
if the workbook
pe represents
d in a
Excel 2003
cers are
, the slicer cannot
d in Excel 2010 or

pe was modified
ier version of
if the workbook
d in Excel 2003
, the slicer cannot
Product - all -
Country - all -

Data
Month Sum - Var Sum - Budget Sum - Revenue Sum - Revenue
January -4297 91831 87534 8.53%
February 2843 87534 90377 8.81%
March -1389 90377 88988 8.67%
April -2774 87756 84982 8.28%
May -423 84982 84559 8.24%
June -548 84559 84011 8.19%
July 2366 84011 86377 8.42%
August -2843 86377 83534 8.14%
September 1389 83534 84923 8.27%
October -4318 84923 80605 7.85%
November 3406 80605 84011 8.19%
December 2366 84011 86377 8.42%
Total Result -4222 1030500 1026278 100.00%
april chip 1 France
37600

Data
Month Product Country Sum - Var Sum - Budget
January -4297 91831
Chip 1 -4297 91831
Canada 2929 29330
France -5772 33171
US -1454 29330
February 2843 87534
Chip 2 2843 87534
Canada 3318 32045
France -3846 32954
US 3371 22535
March -1389 90377
Chip 3 -1389 90377
Canada -10733 35363
France 11529 20784
US -2185 34230
April -2774 87756
Chip 1 -2774 87756
Canada 1054 19289
France -54 37654
US -3774 30813
May -423 84982
Chip 2 -423 84982
Canada 8332 20343
France 3318 32045
US -12073 32594
June -548 84559
Chip 3 -548 84559
Canada -2823 30867
France -3740 36595
US 6015 17097
July 2366 84011
Chip 1 2366 84011
Canada -5114 28044
France -275 27514
US 7755 28453
August -2843 86377
Chip 2 -2843 86377
Canada -3855 27830
France 2769 30663
US -1757 27884
September 1389 83534
Chip 3 1389 83534
Canada -1654 23975
France -2983 32200
US 6026 27359
October -4318 84923
Chip 1 -4318 84923
Canada 1454 27876
France -1917 29217
US -3855 27830
November 3406 80605
Chip 2 3406 80605
Canada 2929 29330
France 0 23876
US 477 27399
December 2366 84011
Chip 3 2366 84011
Canada 1454 27876
France 912 32259
US 0 23876
Total Result -4222 1030500
total revenue
1026278

Sum - Revenue Sum - Revenue


87534 8.53%
87534 8.53%
32259 3.14%
27399 2.67% Month April
27876 2.72%
90377 8.81%
90377 8.81% Chip 1 Chip 2 Chip 3
35363 3.45% Canada 20343 0 0
29108 2.84% France 0 0 0
25906 2.52% US 0 0 0
88988 8.67%
88988 8.67%
24630 2.40% January
32313 3.15% February
32045 3.12% March
84982 8.28% April
84982 8.28% May
20343 1.98% June
37600 3.66% July
27039 2.63% August
84559 8.24% September
84559 8.24% October
28675 2.79% November
35363 3.45% December
20521 2.00%
84011 8.19%
84011 8.19%
28044 2.73%
32855 3.20%
23112 2.25%
86377 8.42%
86377 8.42%
22930 2.23%
27239 2.65%
36208 3.53%
83534 8.14%
83534 8.14%
23975 2.34%
33432 3.26%
26127 2.55%
84923 8.27%
84923 8.27%
22321 2.17%
29217 2.85%
33385 3.25%
80605 7.85%
80605 7.85%
29330 2.86%
27300 2.66%
23975 2.34%
84011 8.19%
84011 8.19%
32259 3.14%
23876 2.33%
27876 2.72%
86377 8.42%
86377 8.42%
29330 2.86%
33171 3.23%
23876 2.33%
1026278 100.00%
Month Product Country Revenue Budget Var
January Chip 1 US 4000 5454 -1454
January Chip 1 Canada 3424 5341 -1917 (empty)
January Chip 1 US 8324 1232 7092 Month
January Chip 1 France 5555 3424 2131 January
January Chip 1 Canada 5341 8324 -2983 February
January Chip 1 US 1232 5555 -4323 March
January Chip 1 France 3424 5341 -1917 April
January Chip 1 Canada 8324 1232 7092 May
January Chip 1 US 5555 3424 2131 June
January Chip 1 France 5341 8324 -2983 July
January Chip 1 Canada 1232 5555 -4323 August
January Chip 1 US 3424 5341 -1917 September
January Chip 1 Canada 8383 5454 2929 October
January Chip 1 France 8324 1232 7092 November
January Chip 1 Canada 5555 3424 2131 December
January Chip 1 US 5341 8324 -2983 Total Result
January Chip 1 France 1232 5555 -4323
January Chip 1 France 3523 9295 -5772
February Chip 2 Canada 5555 3424 2131
February Chip 2 US 5454 4000 1454
February Chip 2 US 5341 8324 -2983
February Chip 2 France 1232 5555 -4323
February Chip 2 Canada 3424 5341 -1917
February Chip 2 US 8324 1232 7092
February Chip 2 France 5555 3424 2131
February Chip 2 Canada 5341 8324 -2983
February Chip 2 US 1232 5555 -4323
February Chip 2 France 3424 5341 -1917
February Chip 2 Canada 8324 1232 7092
February Chip 2 US 5555 3424 2131
February Chip 2 France 5341 8324 -2983
February Chip 2 Canada 9295 8383 912
February Chip 2 France 1232 5555 -4323
February Chip 2 Canada 3424 5341 -1917
February Chip 2 France 8324 1232 7092
February Chip 2 France 4000 3523 477
March Chip 3 Canada 1232 5555 -4323
March Chip 3 US 3424 5341 -1917
March Chip 3 US 8383 5454 2929
March Chip 3 France 8324 1232 7092
March Chip 3 Canada 5555 3424 2131
March Chip 3 US 5341 8324 -2983
March Chip 3 France 1232 5555 -4323
March Chip 3 Canada 3424 5341 -1917
March Chip 3 US 8324 1232 7092
March Chip 3 France 5555 3424 2131
March Chip 3 Canada 5341 8324 -2983
March Chip 3 US 1232 5555 -4323
March Chip 3 France 3424 5341 -1917
March Chip 3 France 8324 1232 7092
March Chip 3 Canada 3523 9295 -5772
March Chip 3 Canada 5555 3424 2131
March Chip 3 US 5341 8324 -2983
March Chip 3 France 5454 4000 1454
April Chip 1 US 5555 3424 2131
April Chip 1 France 5341 8324 -2983
April Chip 1 Canada 1232 5555 -4323
April Chip 1 US 9295 8383 912
April Chip 1 US 3424 5341 -1917
April Chip 1 France 8324 1232 7092
April Chip 1 Canada 5555 3424 2131
April Chip 1 US 5341 8324 -2983
April Chip 1 France 1232 5555 -4323
April Chip 1 France 3424 5341 -1917
April Chip 1 Canada 8324 1232 7092
April Chip 1 France 5555 3424 2131
April Chip 1 France 5341 8324 -2983
April Chip 1 Canada 1232 5555 -4323
April Chip 1 US 3424 5341 -1917
April Chip 1 Canada 4000 3523 477
April Chip 1 France 8383 5454 2929
May Chip 2 US 1232 5555 -4323
May Chip 2 France 3424 5341 -1917
May Chip 2 Canada 8324 1232 7092
May Chip 2 US 5555 3424 2131
May Chip 2 US 3523 9295 -5772
May Chip 2 France 5341 8324 -2983
May Chip 2 Canada 1232 5555 -4323
May Chip 2 US 3424 5341 -1917
May Chip 2 France 8324 1232 7092
May Chip 2 France 5555 3424 2131
May Chip 2 Canada 5341 8324 -2983
May Chip 2 US 1232 5555 -4323
May Chip 2 France 3424 5341 -1917
May Chip 2 Canada 8324 1232 7092
May Chip 2 US 5555 3424 2131
May Chip 2 France 9295 8383 912
May Chip 2 Canada 5454 4000 1454
June Chip 3 US 8324 1232 7092
June Chip 3 France 5555 3424 2131
June Chip 3 Canada 5341 8324 -2983
June Chip 3 US 1232 5555 -4323
June Chip 3 France 3424 5341 -1917
June Chip 3 US 4000 3523 477
June Chip 3 France 8324 1232 7092
June Chip 3 Canada 5555 3424 2131
June Chip 3 France 5341 8324 -2983
June Chip 3 France 1232 5555 -4323
June Chip 3 Canada 3424 5341 -1917
June Chip 3 US 8324 1232 7092
June Chip 3 France 5555 3424 2131
June Chip 3 Canada 5341 8324 -2983
June Chip 3 US 1232 5555 -4323
June Chip 3 France 3424 9295 -5871
June Chip 3 Canada 8383 5454 2929
July Chip 1 US 5341 8324 -2983
July Chip 1 France 1232 5555 -4323
July Chip 1 Canada 3424 5341 -1917
July Chip 1 US 8324 1232 7092
July Chip 1 France 5555 3424 2131
July Chip 1 France 5341 8324 -2983
July Chip 1 US 5454 4000 1454
July Chip 1 Canada 1232 5555 -4323
July Chip 1 US 3424 5341 -1917
July Chip 1 France 8324 1232 7092
July Chip 1 Canada 5555 3424 2131
July Chip 1 US 5341 8324 -2983
July Chip 1 France 1232 5555 -4323
July Chip 1 Canada 3424 5341 -1917
July Chip 1 US 8324 1232 7092
July Chip 1 France 5555 3424 2131
July Chip 1 Canada 9295 8383 912
August Chip 2 US 3424 5341 -1917
August Chip 2 France 8324 1232 7092
August Chip 2 France 5555 3424 2131
August Chip 2 Canada 5341 8324 -2983
August Chip 2 France 1232 5555 -4323
August Chip 2 France 3424 5341 -1917
August Chip 2 Canada 8324 1232 7092
August Chip 2 US 8383 5454 2929
August Chip 2 US 5555 3424 2131
August Chip 2 France 5341 8324 -2983
August Chip 2 Canada 1232 5555 -4323
August Chip 2 US 3424 5341 -1917
August Chip 2 France 8324 1232 7092
August Chip 2 Canada 5555 3424 2131
August Chip 2 US 5341 8324 -2983
August Chip 2 France 1232 5555 -4323
August Chip 2 Canada 3523 9295 -5772
SeptemberChip 3 US 5555 3424 2131
SeptemberChip 3 France 5341 8324 -2983
SeptemberChip 3 France 1232 5555 -4323
SeptemberChip 3 Canada 3424 5341 -1917
SeptemberChip 3 US 8324 1232 7092
SeptemberChip 3 France 5555 3424 2131
SeptemberChip 3 Canada 5341 8324 -2983
SeptemberChip 3 US 1232 5555 -4323
SeptemberChip 3 US 9295 8383 912
SeptemberChip 3 France 3424 5341 -1917
SeptemberChip 3 Canada 8324 1232 7092
SeptemberChip 3 US 5555 3424 2131
SeptemberChip 3 France 5341 8324 -2983
SeptemberChip 3 Canada 1232 5555 -4323
SeptemberChip 3 US 3424 5341 -1917
SeptemberChip 3 France 8324 1232 7092
SeptemberChip 3 Canada 4000 3523 477
October Chip 1 Canada 1232 5555 -4323
October Chip 1 France 3424 5341 -1917
October Chip 1 France 8324 1232 7092
October Chip 1 Canada 5555 3424 2131
October Chip 1 US 5341 8324 -2983
October Chip 1 France 1232 5555 -4323
October Chip 1 Canada 3424 5341 -1917
October Chip 1 US 8324 1232 7092
October Chip 1 France 5555 3424 2131
October Chip 1 US 3523 9295 -5772
October Chip 1 Canada 5341 8324 -2983
October Chip 1 US 1232 5555 -4323
October Chip 1 France 3424 5341 -1917
October Chip 1 Canada 8324 1232 7092
October Chip 1 US 5555 3424 2131
October Chip 1 France 5341 8324 -2983
October Chip 1 Canada 5454 4000 1454
November Chip 2 Canada 8324 1232 7092
November Chip 2 US 5555 3424 2131
November Chip 2 France 5341 8324 -2983
November Chip 2 Canada 1232 5555 -4323
November Chip 2 US 3424 5341 -1917
November Chip 2 France 8324 1232 7092
November Chip 2 Canada 5555 3424 2131
November Chip 2 US 5341 8324 -2983
November Chip 2 France 1232 5555 -4323
November Chip 2 Canada 3424 5341 -1917
November Chip 2 US 4000 3523 477
November Chip 2 US 8324 1232 7092
November Chip 2 France 5555 3424 2131
November Chip 2 Canada 5341 8324 -2983
November Chip 2 US 1232 5555 -4323
November Chip 2 France 3424 5341 -1917
November Chip 2 Canada 8383 5454 2929
December Chip 3 Canada 5341 8324 -2983
December Chip 3 US 1232 5555 -4323
December Chip 3 France 3424 5341 -1917
December Chip 3 Canada 8324 1232 7092
December Chip 3 US 5555 3424 2131
December Chip 3 France 5341 8324 -2983
December Chip 3 Canada 1232 5555 -4323
December Chip 3 US 3424 5341 -1917
December Chip 3 France 8324 1232 7092
December Chip 3 Canada 5555 3424 2131
December Chip 3 US 5341 8324 -2983
December Chip 3 Canada 5454 4000 1454
December Chip 3 France 1232 5555 -4323
December Chip 3 Canada 3424 5341 -1917
December Chip 3 US 8324 1232 7092
December Chip 3 France 5555 3424 2131
December Chip 3 France 9295 8383 912
Product
Chip 1 Chip 2 Chip 3 Total Result

You might also like