Sum of Sales by Year, Month and Category Power

Sum of Sales by Year andBI Desktop

Category Sum of Sales and Sum of Quantity by Category and
Category Category Furniture Office Supplies Technology
Sub-Category
Furniture Sub-Category Accessories Appliances Art Binders
100K 300K
Office Supplies 272K 6K
Sum of Sales

Technology 246K
250K
226K
50K 215K

Sum of Sales

Sum of Quantity
199K 4K
200K 184K
175K 171K
0K 152K
January
February
March
April
May
June
July
August
September
October
November
December
150K 2K
163K
157K
137K
2014 100K
2014 2015 2016 2017 0K
Month 0.0M 0.1M 0.2M 0.3M
Year
Sum of Sales
Sum of Sales by Region
Sum of Sales by Sub-Category
Phones Tables Binders Machines

725.46K 501.24K
(31.58%) (21.82%)

Region
Central
East
South
Chairs
Accessories Bookc… Appli… Furn…
2.30M 38K
Sum of Quantity
West Sum of Sales
391.72K 678.78K
(17.05%) (29.55%)
Storage Copiers
Paper Supplies

Art
 Power BI Desktop
Sales average per Category 2 by Customer Name and Category  Select or drag fields to populate this visual
Category Furniture Office Supplies Technology
Sales average per Category 2

20K

10K

0K
Tamara Cha…
Sean Miller
Edward Ho…
Raymond B…
Tom Ashbr…
Adrian Bart…
Ken Lonsdale
Sanjit Chand
Hunter Lopez
Sanjit Engle
Christopher…
Todd Sumrall
Greg Tran
Becky Martin
Seth Vernon
Caroline Ju…
Clay Ludtke
Maria Etezadi
Karen Ferg…
Bill Shonely
John Lee
Max Jones
Grant Thor…
Helen Wass…
Tom Boeck…
Peter Fuller
Customer Name

Count of Customer Name by Segment City and Customer Name

148
(18.66%)

Segment

793
Consumer
Corporate
Home Office
Count of Customer Name
409
236
(51.58%)
(29.76%)
 percentage Power BI Desktop
Sum of Sales by Sub-Category Sum of Sales by Category and Year
Increase Decrease Total
Year 2014 2015 2016 2017 2018
1.0M

2M
Sum of Sales

Sum of Sales
1M 0.5M

12.47
0M 0.00 24.93
Phones
Chairs
Storage
Tables
Binders
Machines
Accessor…
Copiers
Bookcases
Appliances
Furnishi…
Paper
Supplies
Art
Envelopes
Labels
Fasteners
0.0M
Furniture Office Technology
Supplies
Sub-Category Category

Year Furniture Office Supplies Technology Total

Sum of Sales and Count of Profit by Category, Year and
Category  2014 1,57,192.85 1,51,776.41 1,75,278.23 4,84,247.50
 2015 1,70,518.24 1,37,233.46 1,62,780.81 4,70,532.51
Sum of Sales Count of Profit
 2016 1,98,901.44 1,83,939.98 2,26,364.18 6,09,205.60
Furniture Office Supplies  2017 2,15,387.27 2,46,097.18 2,71,730.81 7,33,215.26
2K Total 7,41,999.80 7,19,047.03 8,36,154.03 22,97,200.86
Count…
Sum …

0.2M
1K
0.0M 0K

Technology
2K

1.56K 286.40K
Count…
Sum …

0.2M
1K
0.0M 0K

2014 2016 2018 2014 2016 2018 Sum of Discount Sum of Profit
Year Year
Sum of Sales by Year and Category Power BI Desktop Count of Order Date by Order ID
Sum of Sales by Sub-Category and Region
Category Furniture Office Supplies Technology
Phones Tables Binders Machines

East Central
2017 Ce… W…
West East S…

West South

2.30M
2016 Ce… East East S… West
Chairs
Accessories Appli… Fur…
Year

West
Central E…
2015 East Sou… Sum of Sales
Copiers C…
East South
Storage Paper
West
2014
Bookcases
0.0M 0.5M West South Supplies
Sum of Sales

Sum of Sales and Sum of Quantity by Year

Product Name Sum of Quantity
Sum of Sales Sum of Quantity 
Staples 215
Staple envelope 170
0.7M 12K Easy-staple paper 150
Staples in misc. colors 86
Sum of Quantity
Sum of Sales

KI Adjustable-Height Table 74
Avery Non-Stick Binders 71
0.6M 10K
Storex Dura Pro Binders 71
GBC Premium Transparent Covers with Diagonal Lined Pattern 67
Situations Contoured Folding Chairs, 4/Set 64
0.5M 8K Staple-based wall hangings 62
Chromcraft Round Conference Tables 61
2014 2015 2016 2017 Eldon Wave Desk Accessories 61
Year Total 37873
 Sum of Sales
Power BIby Region
Desktop
At 76,381.39, California had the

49
Sum of Profit by State highest Sum of Profit and was
West Central
396.86% higher than Texas, which
had the lowest Sum of Profit at
-25,729.36. Count of State
California accounted for 15.82% of
Sum of Profit.

Across all 49 State, Sum of Profit

ranged from -25,729.36 to 76,381.39.
East
South
California
First State

West
©
© 2024
2024 TomTom,
TomTom, ©
© 2024
2024 Microsoft
Microsoft Corporation
Corporation
First Region
Quantity 1 2
Sum of Sales by City Sum of Sales by State and Year
State Sum of Profit Sum of Sales Sum of Profit Sum of Sale
8K
Year 2014 2015 2016 2017
Alabama 157.43 616.34 414.85 1,746.6
Arizona 51.70 1,089.06 -362.70 5,219.5
150K
6K Arkansas 6.43 37.30 1,244.70 2,903.7
California 1,888.55 9,864.05 10,380.67 60,218.6
Sum of Sales

Colorado 123.18 904.53 -654.23 5,849.0

Connecticut 73.22 524.60 553.28 1,892.0
Sum of Sales

4K
100K Delaware 68.26 231.77 879.28 3,030.3
District of Columbia 26.10 60.0
Florida -94.98 1,800.38 760.47 9,761.4
2K
Georgia 880.72 2,045.17 863.99 2,977.2
50K Idaho 4.47 12.89 181.33 776.3
Illinois -311.25 1,499.11 -506.59 12,723.9
0K
rs n k a rk ry son and ket ipa Indiana 199.42 857.02 1,703.79 5,367.9
ke ngto stoc Yum Yo dbu il l c a
n
Yo ilmi ood oo W ood nso Yuc Iowa 18.07 44.94 49.03 147.5
W W oo California New York Texas
W W W Kansas 9.79 39.10 437.18 1,503.6
State Total 7,440.48 53,251.93 38,448.41 2,89,091.4
City
 Power BI Desktop
Sum of Profit and Sum of Discount by Sales
8 Product Name Sum of Discount

Acco D-Ring Binder w/DublLock 5.60
Avery Non-Stick Binders 6.80
6 Avery Self-Adhesive Photo Pockets for Polaroid Photos 5.90
Sum of Discount

GBC Instant Report Kit 6.40

GBC Premium Transparent Covers with Diagonal Lined Pattern 5.60
4 GBC Standard Recycled Report Covers, Clear Plastic Sheets 5.90
GBC Standard Therm-A-Bind Covers 5.80
Premier Elliptical Ring Binder, Black 5.80
2 Pressboard Covers with Storage Hooks, 9 1/2" x 11", Light Blue 5.40
Storex Dura Pro Binders 7.20
Total 60.40
0
-10K -5K 0K 5K 10K
Sum of Profit

1.56K 0.16 -0.05 0.12

Sum of Discount Average of Discount Profit and Discount correlation for Product Name profitratio
Sum of Sales by Quarter and Year Sum of Sales by Year
Power and Sub-Category
BI Desktop

Year 2014 2015 2016 2017 Sub-Category Accesso… Applian… Art Binders Bookcas… Chairs Copiers Envelopes Fasteners
0.8M
0.3M

0.6M
Sum of Sales

Sum of Sales
0.2M
0.4M

0.2M
0.1M

Qtr 1 Qtr 2 Qtr 3 Qtr 4 0.0M

2014 2015 2016 2017
Quarter Year

Year × Quarter × Month

2014 Qtr 1

2014 Qtr 1 January

Sum of Sales
4,84,247.50

2015
74,447.80

Qtr 2
14,236.90

February
9994
22,97,200.86 4,70,532.51 86,538.76 4,519.89 Count of Order ID

2016 Qtr 3 March

6,09,205.60 1,43,633.21 55,691.01

 
 Power BI Desktop
Sum of Profit by Sub-Category Sum of Sales by Product Name and Category
Category Office Supplies Technology
Copiers
Phones
Accessories
Zebra ZM400 Thermal La…
Paper
Binders
Chairs Zebra GX420t Direct The…

Product Name
Storage
Sub-Category

Appliances Zebra GK420t Direct The…

Furnishings
Envelopes
Zebra Zazzle Fluorescent…
Art
Labels
Machines Zipper Ring Binder Pock…
Fasteners
Supplies 0K 1K 2K 3K 4K 5K 6K 7K
Bookcases Sum of Sales
Tables
-100% -50% 0% 50% 100%
Sum of Quantity and Sum of Discount byProfit
Sum of Sub-Category
Sum of Quantity Sum of Discount
3
Sum of Quantity and …

5K Count of Category

0K

Bi
n
rs er
rn
…
P
es
de Pap ishi hon orag
St
e t
ce C
s
p l L
s
T
s
ste
s
el
Fa Env Boo
s
kc
s
p
Su Ma
s
ch
s
Ar so… hair ian… bel ble ner ope ase plie ine pier
s a a
Co
s 17
Fu Ac Ap Count of Sub-Category
Sub-Category
Sum of Sales by Segment and Category
Power BI Desktop Sum of Sales and Sum of Quantity by Category
Category Furniture Office Supplies Technology

0.4M

0.3M

836.15K
Sum of Sales

0.2M
Goal: 6939 (+11950.07%)

0.1M

0.0M
Consumer Corporate Home Office
Segment
 Sum of Sales by Year and Region Power BI Desktop Sum of Sales by Region
Central East 0.8M
Sum of Sales

0.2M
0.6M

Sum of Sales
0.0M

0.4M
South West
Sum of Sales

0.2M
0.2M

0.0M
0.0M
2014 2015 2016 2017 2014 2015 2016 2017
West East Central South
Year Year
Sum of Profit by Category (groups) and Region
Region

Central East
Category (groups)

Furniture
Office Supplies
Technology
Region 

 Central
South West
 East
Category (groups)

Furniture  South
Office Supplies  West
Technology

0K 50K 0K 50K
Sum of Profit Sum of Profit