Country Sum of sales City Sum of sales CustomerName
UnitedStates 32764.1 Berlin 2892.51 CraigRelter
Total Result 32764.1 Brisbane 10350.34 Jane Waco
Concord 12892.92 JimMitchum
Deter 2832.96 Joseph Hot
Hamilton 15734.52 Justin ites
New York 4619.3 Katherine
Porua 1822.08 MickBrown
Sacramento 15251.88 RickHansen
Sydney 2862.68 ToySwindell
Wollongong 7418.8 Total Result
Total Result 76677.99
This shape represents a slicer. This shape represents a slicer
Slicers can be used in at least Slicers can be used in at least
Excel 2010. Excel 2010.
If the shape was modified in If the shape was modified in
an earlier version of Excel, or an earlier version of Excel, or
if the workbook was saved in if the workbook was saved in
Excel 2003 or earlier, the Excel 2003 or earlier, the
slicer cannot be used. slicer cannot be used.
Sum of sales categories Sum of quantity profit
10350.34 Furniture 79
15251.88 Office Suppli 15
2862.68 Technology 50
12892.92 Total Result 144
7418.8
2892.51
15734.52
7452.26
1822.08
76677.99
This shape represents a slicer.
This shape represents a slicer.
Slicers can be used in at least
Slicers can be used in at least
Excel 2010.
Excel 2010.
If the shape was modified in
If the shape was modified in an
an earlier version of Excel, or
earlier version of Excel, or if the
if the workbook was saved in
workbook was saved in Excel
Excel 2003 or earlier, the
2003 or earlier, the slicer cannot
slicer cannot be used.
be used.
144
79
50
15
Furniture Office Suppli Technology Total Result
15251.88
12892.92
10350.34
2862.68
Craig Jane Waco Jim Joseph Hot
Relter Mitchum
144
TotaL SALES BY COUNTRY
32764.1
32764.1
United Total Result
Total Result States
Deter 2832.96
12892.92
Concord 12892.92
Brisbane 10350.34
Joseph Hot Berlin 2892.51
SALES DASHBOARD 2
TOTAL SALES AVERAGE SALES
4035.683684
16986.
13
This shape represents a slicer.
Slicers are supported in Excel
2010 or later. UNIT QTY
If the shape was modified in
an earlier version of Excel, or
if the workbook was saved in
Excelshape
This 2003represents
or earlier, athe 144
slicer cannot
slicer. Slicers be
areused.
supported
in Excel 2010 or later.
If the shape was modified in
an earlier version of Excel, 79
or if the workbook was saved
in Excel 2003 or earlier, the
50
slicer cannot be used.
This shape represents a
slicer. Slicers are supported
15
in Excel 2010 or later.
Furniture Office Suppli Technology Total Result
If the shape was modified in
an earlier version of Excel,
or if the workbook was saved
in Excel 2003 or earlier, the
slicer cannot be used.
TOTAL PROFIT
Deter 2832.96
Concord 12892.92
Brisbane 10350.34
Berlin 2892.51
Brisbane 10350.34
Berlin 2892.51
BOARD 2025
UNIT QTY TOTAL PROFIT TOTAL
144 7451.877 65483.77
Y TOTAL SHIPPING COST
144 15251.88
12892.92
10350.34
2862.68
Craig Jane Waco Jim Joseph Hot
Relter Mitchum
ogy Total Result
IT AVERAGE SALES
TotaL SALES BY COUNTRY
12892.92
32764.1
32764.1
10350.34
United Total Result
States
32764.1
10350.34
United Total Result
States
TOTAL
65483.77
Order Ship Customer
Date Date
07- Name
Rick Segment City State
7/31/2012 2012
02- Hansen Consumer New York New
New York
South
2/5/2013 2013
10- Justin
Craig ites Corporate Wollongong Wales
10/17/2013 2013
01- Relter Consumer
Home Brisbane Queensland
1/11/2013 2013
11- Katherine
Rick Office Berlin Berlin
11/15/2013 2013
07- Hansen
Jim Consumer Deter Dakar
New South
6/24/2013 2013
11- Mitchum
Toy Corporate Sydney Wales
11/8/2011 2011
01- Swindell
Mick Consumer Porua Wellington
21-
1/14/2012 2012
10- Brown Consumer Hamilton Waikato
10/14/2014 2014 Jane Waco Corporate Sacramento California
31- North
11/10/2012 01-
01-2012 Joseph
Mick Hot Consumer Concord Carolina
1/14/2012 2012
10- Brown Consumer Hamilton Waikato
10/14/2014 2014
31- Jane Waco Corporate Sacramento California
North
11/10/2012 01-2012
31- Joseph
Mick Hot Consumer Concord Carolina
11/11/2012 01-2013
31- Brown Consumer Hamilton Waikato
11/12/2012 01-2014
31- Jane Waco Corporate Sacramento California
North
11/13/2012 01-2015
07- Joseph
Rick Hot Consumer Concord Carolina
7/31/2012 2012
02- Hansen Consumer New York New
New York
South
2/5/2013 2013
10- Justin
Craig ites Corporate Wollongong Wales
10/17/2013 2013 Relter Consumer Brisbane Queensland
sub quantity
Country
United Product ID categories categories sales profit profit
States TECACI000303 Technology Accessories 2309.65 7 762.185
Australia FURCHAOO03 Furniture Chairs 3709.4 9 -288.77
Australia TECPH-IOQQN Technology Phones 5175.17 9 919.971
Germany TECPHAGOOIS Technology Phones 2892.51 5 -96.54
Senegal TECSHAAOQO Technology Copiers 2832.96 8 311.52
Australia
New TECPH-OQ000 Technology Phones 2862.68 5 763.275
Zealand
New FURCHACOOM Furniture Chairs 1822.08 4 564.84
Zealand
United FURTALOOGQ9 Furniture Tables 5244.84 6 996.48
States OF-B-1000352 Office Suppli Binders 5083.96 5 1906.49
United
States
New FURTALOOO01 Furniture Tables 4297.64 13 -1862.3
Zealand
United FURTALOOGQ9 Furniture Tables 5244.84 6 996.48
States
United OF-B-1000352 Office Suppli Binders 5083.96 5 1906.49
States
New FURTALOOO01 Furniture Tables 4297.64 13 -1862.3
Zealand
United FURTALOOGQ9 Furniture Tables 5244.84 6 996.48
States
United OF-B-1000352 Office Suppli Binders 5083.96 5 1906.49
States
United FURTALOOO01 Furniture Tables 4297.64 13 -1862.3
States TECACI000303 Technology Accessories 2309.65 7 762.185
Australia FURCHAOO03 Furniture Chairs 3709.4 9 -288.77
Australia TECPH-IOQQN Technology Phones 5175.17 9 919.971
shipping order
cost priority
933.57 Critical
923.63 Critical AVERAGE SALES
915.49 Medium 4035.684
910.16 Medium TOTAL SHIPPING COST
903.04 Critical 16986.13
897.35 Critical TOTAL PROFIT
894.77 Critical 7451.877
878.38 High UNIT SOLD
867.69 Low 144
865.74 Critical
878.38 High sales
867.69 Low 65483.77
865.74 Critical
878.38 High UNIT SOLD
867.69 Low 144
865.74 Critical
933.57 Critical
923.63 Critical
915.49 Medium