sales.xlsx

	A	B	C	D	E	F	H	I
1
2
3	Row Labels	Sum of Sales
4	Anna Andreadi	31٫58%
5	Cassandra Brandow	17٫05%
6	Chuck Magee	29٫54%			Row Labels	Sum of Profit	Row Labels	Sum of Sales
7	Kelly Williams	21٫82%			New York City	62036٫9837	1	94924٫8356
8	Grand Total	100٫00%			Los Angeles	30440٫7579	2	59751٫2514
9					Seattle	29156٫0967	3	205005٫4888
10					San Francisco	17507٫3854	4	137480٫7566
11					Detroit	13181٫7908	5	155028٫8117
12					Grand Total	152323٫0145	6	152718٫6793
13	Row Labels	Sum of Sales	Sum of revenue				7	147238٫097
14	Furniture	741718٫4233	3858416٫885				8	159044٫063
15	Office Supplies	719047٫032	3541918٫904				9	307649٫9457
16	Technology	836154٫033	4080261٫525		Row Labels	Sum of Cost	10	200322٫9847
17	Grand Total	2296919٫488	11480597٫31		Accessories	836985٫8863	11	352461٫071
18					Appliances	529230٫4496	12	325293٫5035
19					Art	129493٫325	Grand Total	2296919٫488
20	Distinct Count of Product ID	Sum of Sales	Sum of Profit	Distinct Count of Customer ID	Binders	979625٫0117
21	1862	2296919٫488	286409٫0805	793	Bookcases	601298٫6809
22					Chairs	1635592٫996
23					Copiers	602103٫3451
24					Envelopes	67215٫1733
25					Fasteners	16108٫2738
26					Furnishings	440822٫0684
27					Labels	64386٫822
28					Machines	911405٫1181
29					Paper	353562٫9967
30					Phones	1584312٫227
31					Storage	1077373٫758
32					Supplies	202432٫2935
33					Tables	1162239٫808
34					Grand Total	11194188٫23
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100