0% found this document useful (0 votes)
55 views2 pages

Pivot Chart

The document contains sales data from different years, quarters and months including country, showroom, customer, age and products. It lists cost of sales, revenue, profit, profit percentage, commission percentage and commission for each period.

Uploaded by

Juaquim Aredidon
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)
55 views2 pages

Pivot Chart

The document contains sales data from different years, quarters and months including country, showroom, customer, age and products. It lists cost of sales, revenue, profit, profit percentage, commission percentage and commission for each period.

Uploaded by

Juaquim Aredidon
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

Year Quarter Month Country Showroom Customer Name Age Products

2017 1 January United States Amazon Kevin Thomas 26 TV


2017 2 February United Kingdom Wallmart Peter Max 28 AC
2017 3 March Canada Wallgreen Ria Sen 32 Fridge
2017 4 April Norway Ebay Chris Luka 33 Grinder
2017 1 May Singapore Amazon Kate Joseph 35 TV
2017 2 June Malaysia Wallmart Peter Rossario 39 AC
2017 3 July UAE Wallgreen James Cameron 35 Fridge
2017 4 August Finland Ebay Max Fellar 36 Grinder
2017 1 September Switzerland Amazon John Pencil 34 TV
2017 2 October Germany Wallmart Stone Dizuza 32 AC
2017 3 November United States Wallgreen Kerry Wells 30 Fridge
2017 4 December United Kingdom Ebay Maxmilan Stencil 29 Grinder
2016 1 January United States Amazon Kevin Thomas 28 TV
2016 2 February United Kingdom Wallmart Peter Max 39 AC
2016 3 March Canada Wallgreen Ria Sen 26 Fridge
2016 4 April Norway Ebay Chris Luka 24 Grinder
2016 1 May Singapore Amazon Kate Joseph 23 TV
2016 2 June Malaysia Wallmart Peter Rossario 25 AC
2016 3 July UAE Wallgreen James Cameron 39 Fridge
2016 4 August Finland Ebay Max Fellar 42 Grinder
2016 1 September Switzerland Amazon John Pencil 35 TV
2016 2 October Germany Wallmart Stone Dizuza 36 AC
2016 3 November United States Wallgreen Kerry Wells 22 Fridge
2016 4 December United Kingdom Ebay Maxmilan Stencil 20 Grinder
2015 1 January United States Amazon Kevin Thomas 28 TV
2015 2 February United Kingdom Wallmart Peter Max 31 AC
2015 3 March Canada Wallgreen Ria Sen 30 Fridge
2015 4 April Norway Ebay Chris Luka 33 Grinder
2015 1 May Singapore Amazon Kate Joseph 28 TV
2015 2 June Malaysia Wallmart Peter Rossario 29 AC
2015 3 July UAE Wallgreen James Cameron 36 Fridge
2015 4 August Finland Ebay Max Fellar 30 Grinder
2015 1 September Switzerland Amazon John Pencil 24 TV
2015 2 October Germany Wallmart Stone Dizuza 28 AC
2015 3 November United States Wallgreen Kerry Wells 29 Fridge
2015 4 December United Kingdom Ebay Maxmilan Stencil 27 Grinder
Cost of Sales Revenue Profit % Profit Commission % Commission
$900 $1,200 0.33 $300 0.15 $180
$600 $900 0.50 $300 0.18 $162
$800 $1,050 0.31 $250 0.14 $147
$700 $900 0.29 $200 0.16 $144
$950 $1,300 0.37 $350 0.15 $195
$650 $1,000 0.54 $350 0.18 $180
$880 $1,100 0.25 $220 0.14 $154
$770 $1,000 0.30 $230 0.16 $160
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$680 $910 0.34 $230 0.16 $146
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$680 $910 0.34 $230 0.16 $146
$950 $1,300 0.37 $350 0.15 $195
$650 $1,000 0.54 $350 0.18 $180
$900 $1,200 0.33 $300 0.15 $180
$600 $900 0.50 $300 0.18 $162
$800 $1,050 0.31 $250 0.14 $147
$700 $900 0.29 $200 0.16 $144
$950 $1,300 0.37 $350 0.15 $195
$680 $910 0.34 $230 0.16 $146
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$880 $1,100 0.25 $220 0.14 $154
$770 $1,000 0.30 $230 0.16 $160
$850 $1,150 0.35 $300 0.15 $173
$550 $900 0.64 $350 0.18 $162
$750 $920 0.23 $170 0.14 $129
$800 $1,050 0.31 $250 0.14 $147
$800 $1,050 0.31 $250 0.14 $147
$700 $900 0.29 $200 0.16 $144
$680 $910 0.34 $230 0.16 $146

You might also like