mis week 4

profilemometag
in_class_assignment.xls
Home>Business & Finance homework help>Management homework help>mis week 4

Filter

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 1/6/12 United States
2 Broccoli Vegetables $8,239 1/7/12 United Kingdom
3 Banana Fruit $617 1/8/12 United States
4 Banana Fruit $8,384 1/10/12 Canada
5 Beans Vegetables $2,626 1/10/12 Germany
6 Orange Fruit $3,610 1/11/12 United States
7 Broccoli Vegetables $9,062 1/11/12 Australia
8 Banana Fruit $6,906 1/16/12 New Zealand
9 Apple Fruit $2,417 1/16/12 France
10 Apple Fruit $7,431 1/16/12 Canada
11 Banana Fruit $8,250 1/16/12 Germany
12 Broccoli Vegetables $7,012 1/18/12 United States
13 Carrots Vegetables $1,903 1/20/12 Germany
14 Broccoli Vegetables $2,824 1/22/12 Canada
15 Apple Fruit $6,946 1/24/12 France
16 Banana Fruit $2,320 1/27/12 United Kingdom
17 Banana Fruit $2,116 1/28/12 United States
18 Banana Fruit $1,135 1/30/12 United Kingdom
19 Broccoli Vegetables $3,595 1/30/12 United Kingdom
20 Apple Fruit $1,161 2/2/12 United States
21 Orange Fruit $2,256 2/4/12 France
22 Banana Fruit $1,004 2/11/12 New Zealand
23 Banana Fruit $3,642 2/14/12 Canada
24 Banana Fruit $4,582 2/17/12 United States
25 Beans Vegetables $3,559 2/17/12 United Kingdom
26 Carrots Vegetables $5,154 2/17/12 Australia
27 Mango Fruit $7,388 2/18/12 France
28 Beans Vegetables $7,163 2/18/12 United States
29 Beans Vegetables $5,101 2/20/12 Germany
30 Apple Fruit $7,602 2/21/12 France
31 Mango Fruit $1,641 2/22/12 United States
32 Apple Fruit $8,892 2/23/12 Australia
33 Apple Fruit $2,060 2/29/12 France
34 Broccoli Vegetables $1,557 2/29/12 Germany
35 Apple Fruit $6,509 3/1/12 France
36 Apple Fruit $5,718 3/4/12 Australia
37 Apple Fruit $7,655 3/5/12 United States
38 Carrots Vegetables $9,116 3/5/12 United Kingdom
39 Banana Fruit $2,795 3/15/12 United States
40 Banana Fruit $5,084 3/15/12 United States
41 Carrots Vegetables $8,941 3/15/12 United Kingdom
42 Broccoli Vegetables $5,341 3/16/12 France
43 Banana Fruit $135 3/19/12 Canada
44 Banana Fruit $9,400 3/19/12 Australia
45 Beans Vegetables $6,045 3/21/12 Germany
46 Apple Fruit $5,820 3/22/12 New Zealand
47 Orange Fruit $8,887 3/23/12 Germany
48 Orange Fruit $6,982 3/24/12 United States
49 Banana Fruit $4,029 3/26/12 Australia
50 Carrots Vegetables $3,665 3/26/12 Germany
51 Banana Fruit $4,781 3/29/12 France
52 Mango Fruit $3,663 3/30/12 Australia
53 Apple Fruit $6,331 4/1/12 France
54 Apple Fruit $4,364 4/1/12 Canada
55 Carrots Vegetables $607 4/3/12 United Kingdom
56 Banana Fruit $1,054 4/6/12 New Zealand
57 Carrots Vegetables $7,659 4/6/12 United States
58 Broccoli Vegetables $277 4/12/12 Germany
59 Banana Fruit $235 4/17/12 United States
60 Orange Fruit $1,113 4/18/12 Australia
61 Apple Fruit $1,128 4/21/12 United States
62 Broccoli Vegetables $9,231 4/22/12 Canada
63 Banana Fruit $4,387 4/23/12 United States
64 Apple Fruit $2,763 4/25/12 Canada
65 Banana Fruit $7,898 4/27/12 United Kingdom
66 Banana Fruit $2,427 4/30/12 France
67 Banana Fruit $8,663 5/1/12 New Zealand
68 Carrots Vegetables $2,789 5/1/12 Germany
69 Banana Fruit $4,054 5/2/12 United States
70 Mango Fruit $2,262 5/2/12 United States
71 Mango Fruit $5,600 5/2/12 United Kingdom
72 Banana Fruit $5,787 5/3/12 United States
73 Orange Fruit $6,295 5/3/12 Canada
74 Banana Fruit $474 5/5/12 Germany
75 Apple Fruit $4,325 5/5/12 France
76 Banana Fruit $592 5/6/12 United States
77 Orange Fruit $4,330 5/8/12 United States
78 Banana Fruit $9,405 5/8/12 United Kingdom
79 Apple Fruit $7,671 5/8/12 France
80 Carrots Vegetables $5,791 5/8/12 United Kingdom
81 Banana Fruit $6,007 5/12/12 Canada
82 Banana Fruit $5,030 5/14/12 Germany
83 Carrots Vegetables $6,763 5/14/12 United Kingdom
84 Banana Fruit $4,248 5/15/12 Australia
85 Banana Fruit $9,543 5/16/12 France
86 Broccoli Vegetables $2,054 5/16/12 United Kingdom
87 Beans Vegetables $7,094 5/16/12 Germany
88 Carrots Vegetables $6,087 5/18/12 United States
89 Apple Fruit $4,264 5/19/12 Australia
90 Mango Fruit $9,333 5/20/12 United States
91 Mango Fruit $8,775 5/22/12 Germany
92 Broccoli Vegetables $2,011 5/23/12 United Kingdom
93 Banana Fruit $5,632 5/25/12 United States
94 Banana Fruit $4,904 5/25/12 New Zealand
95 Beans Vegetables $1,002 5/25/12 Australia
96 Orange Fruit $8,141 5/26/12 United Kingdom
97 Orange Fruit $3,644 5/26/12 Canada
98 Orange Fruit $1,380 5/26/12 Australia
99 Broccoli Vegetables $8,354 5/26/12 Germany
100 Banana Fruit $5,182 5/27/12 United States
101 Apple Fruit $2,193 5/27/12 France
102 Mango Fruit $3,647 5/28/12 United States
103 Apple Fruit $4,104 5/28/12 United States
104 Carrots Vegetables $7,457 5/28/12 United States
105 Mango Fruit $3,767 5/29/12 Canada
106 Broccoli Vegetables $4,685 5/30/12 Germany
107 Banana Fruit $3,917 6/4/12 United States
108 Apple Fruit $521 6/4/12 Canada
109 Apple Fruit $5,605 6/10/12 France
110 Broccoli Vegetables $9,630 6/11/12 Germany
111 Banana Fruit $6,941 6/20/12 Canada
112 Broccoli Vegetables $7,231 6/20/12 United Kingdom
113 Broccoli Vegetables $8,891 6/23/12 Australia
114 Banana Fruit $107 6/25/12 France
115 Banana Fruit $4,243 6/26/12 United States
116 Orange Fruit $4,514 6/27/12 United States
117 Mango Fruit $5,480 7/2/12 United States
118 Banana Fruit $5,002 7/2/12 France
119 Banana Fruit $8,530 7/5/12 Canada
120 Orange Fruit $4,819 7/7/12 New Zealand
121 Broccoli Vegetables $6,343 7/11/12 United Kingdom
122 Orange Fruit $2,318 7/13/12 United Kingdom
123 Orange Fruit $220 7/20/12 United Kingdom
124 Orange Fruit $6,341 7/20/12 New Zealand
125 Apple Fruit $330 7/20/12 Germany
126 Broccoli Vegetables $3,027 7/20/12 United Kingdom
127 Orange Fruit $850 7/22/12 New Zealand
128 Banana Fruit $8,986 7/23/12 United Kingdom
129 Broccoli Vegetables $3,800 7/25/12 United States
130 Carrots Vegetables $5,751 7/28/12 United Kingdom
131 Apple Fruit $1,704 7/29/12 United Kingdom
132 Banana Fruit $7,966 7/30/12 Australia
133 Banana Fruit $852 7/31/12 United States
134 Beans Vegetables $8,416 7/31/12 Australia
135 Banana Fruit $7,144 8/1/12 France
136 Broccoli Vegetables $7,854 8/1/12 United States
137 Orange Fruit $859 8/3/12 United States
138 Broccoli Vegetables $8,049 8/12/12 United States
139 Banana Fruit $2,836 8/13/12 Germany
140 Carrots Vegetables $1,743 8/19/12 United States
141 Apple Fruit $3,844 8/23/12 France
142 Apple Fruit $7,490 8/24/12 France
143 Broccoli Vegetables $4,483 8/25/12 Germany
144 Apple Fruit $7,333 8/27/12 Canada
145 Carrots Vegetables $7,654 8/28/12 United States
146 Apple Fruit $3,944 8/29/12 United Kingdom
147 Beans Vegetables $5,761 8/29/12 Germany
148 Banana Fruit $6,864 9/1/12 New Zealand
149 Banana Fruit $4,016 9/1/12 Germany
150 Banana Fruit $1,841 9/2/12 United States
151 Banana Fruit $424 9/5/12 Australia
152 Banana Fruit $8,765 9/7/12 United Kingdom
153 Banana Fruit $5,583 9/8/12 United States
154 Broccoli Vegetables $4,390 9/9/12 New Zealand
155 Broccoli Vegetables $352 9/9/12 Canada
156 Apple Fruit $8,489 9/11/12 United States
157 Banana Fruit $7,090 9/11/12 France
158 Banana Fruit $7,880 9/15/12 United States
159 Orange Fruit $3,861 9/18/12 United States
160 Broccoli Vegetables $7,927 9/19/12 Germany
161 Banana Fruit $6,162 9/20/12 United States
162 Mango Fruit $5,523 9/25/12 Australia
163 Broccoli Vegetables $5,936 9/25/12 United Kingdom
164 Carrots Vegetables $7,251 9/26/12 Germany
165 Orange Fruit $6,187 9/27/12 Australia
166 Banana Fruit $3,210 9/29/12 Germany
167 Carrots Vegetables $682 9/29/12 Germany
168 Banana Fruit $793 10/3/12 Australia
169 Carrots Vegetables $5,346 10/4/12 Germany
170 Banana Fruit $7,103 10/7/12 New Zealand
171 Carrots Vegetables $4,603 10/10/12 United States
172 Apple Fruit $8,160 10/16/12 France
173 Apple Fruit $7,171 10/23/12 United Kingdom
174 Banana Fruit $3,552 10/23/12 New Zealand
175 Banana Fruit $7,273 10/25/12 Australia
176 Banana Fruit $2,402 10/26/12 Germany
177 Banana Fruit $1,197 10/26/12 Australia
178 Beans Vegetables $5,015 10/26/12 Australia
179 Orange Fruit $5,818 11/2/12 United States
180 Banana Fruit $4,399 11/3/12 United Kingdom
181 Carrots Vegetables $3,011 11/3/12 United States
182 Apple Fruit $4,715 11/9/12 United Kingdom
183 Apple Fruit $5,321 11/12/12 France
184 Banana Fruit $8,894 11/15/12 United States
185 Carrots Vegetables $4,846 11/25/12 United Kingdom
186 Broccoli Vegetables $284 11/25/12 Germany
187 Orange Fruit $8,283 11/26/12 United Kingdom
188 Orange Fruit $9,990 11/28/12 Canada
189 Banana Fruit $9,014 11/28/12 Australia
190 Apple Fruit $1,942 11/29/12 France
191 Banana Fruit $7,223 11/30/12 United States
192 Carrots Vegetables $4,673 12/2/12 United States
193 Carrots Vegetables $9,104 12/4/12 France
194 Apple Fruit $6,078 12/5/12 United States
195 Beans Vegetables $3,278 12/6/12 Germany
196 Banana Fruit $136 12/12/12 Canada
197 Banana Fruit $8,377 12/12/12 Australia
198 Banana Fruit $2,382 12/12/12 United States
199 Banana Fruit $8,702 12/15/12 Germany
200 Banana Fruit $5,021 12/16/12 United States
201 Apple Fruit $1,760 12/16/12 Australia
202 Banana Fruit $4,766 12/18/12 Germany
203 Beans Vegetables $1,541 12/19/12 United Kingdom
204 Orange Fruit $2,782 12/20/12 United Kingdom
205 Apple Fruit $2,455 12/20/12 Canada
206 Apple Fruit $4,512 12/22/12 New Zealand
207 Apple Fruit $8,752 12/22/12 Germany
208 Carrots Vegetables $9,127 12/25/12 United States
209 Apple Fruit $1,777 12/28/12 France
210 Beans Vegetables $680 12/28/12 France
211 Orange Fruit $958 12/29/12 United States
212 Carrots Vegetables $2,613 12/29/12 Australia
213 Carrots Vegetables $339 12/30/12 Australia

Conditional Formatting

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 1/6/12 United States
2 Broccoli Vegetables $8,239 1/7/12 United Kingdom
3 Banana Fruit $617 1/8/12 United States
4 Banana Fruit $8,384 1/10/12 Canada
5 Beans Vegetables $2,626 1/10/12 Germany
6 Orange Fruit $3,610 1/11/12 United States
7 Broccoli Vegetables $9,062 1/11/12 Australia
8 Banana Fruit $6,906 1/16/12 New Zealand
9 Apple Fruit $2,417 1/16/12 France
10 Apple Fruit $7,431 1/16/12 Canada
11 Banana Fruit $8,250 1/16/12 Germany
12 Broccoli Vegetables $7,012 1/18/12 United States
13 Carrots Vegetables $1,903 1/20/12 Germany
14 Broccoli Vegetables $2,824 1/22/12 Canada
15 Apple Fruit $6,946 1/24/12 France
16 Banana Fruit $2,320 1/27/12 United Kingdom
17 Banana Fruit $2,116 1/28/12 United States
18 Banana Fruit $1,135 1/30/12 United Kingdom
19 Broccoli Vegetables $3,595 1/30/12 United Kingdom
20 Apple Fruit $1,161 2/2/12 United States
21 Orange Fruit $2,256 2/4/12 France
22 Banana Fruit $1,004 2/11/12 New Zealand
23 Banana Fruit $3,642 2/14/12 Canada
24 Banana Fruit $4,582 2/17/12 United States
25 Beans Vegetables $3,559 2/17/12 United Kingdom
26 Carrots Vegetables $5,154 2/17/12 Australia
27 Mango Fruit $7,388 2/18/12 France
28 Beans Vegetables $7,163 2/18/12 United States
29 Beans Vegetables $5,101 2/20/12 Germany
30 Apple Fruit $7,602 2/21/12 France
31 Mango Fruit $1,641 2/22/12 United States
32 Apple Fruit $8,892 2/23/12 Australia
33 Apple Fruit $2,060 2/29/12 France
34 Broccoli Vegetables $1,557 2/29/12 Germany
35 Apple Fruit $6,509 3/1/12 France
36 Apple Fruit $5,718 3/4/12 Australia
37 Apple Fruit $7,655 3/5/12 United States
38 Carrots Vegetables $9,116 3/5/12 United Kingdom
39 Banana Fruit $2,795 3/15/12 United States
40 Banana Fruit $5,084 3/15/12 United States
41 Carrots Vegetables $8,941 3/15/12 United Kingdom
42 Broccoli Vegetables $5,341 3/16/12 France
43 Banana Fruit $135 3/19/12 Canada
44 Banana Fruit $9,400 3/19/12 Australia
45 Beans Vegetables $6,045 3/21/12 Germany
46 Apple Fruit $5,820 3/22/12 New Zealand
47 Orange Fruit $8,887 3/23/12 Germany
48 Orange Fruit $6,982 3/24/12 United States
49 Banana Fruit $4,029 3/26/12 Australia
50 Carrots Vegetables $3,665 3/26/12 Germany
51 Banana Fruit $4,781 3/29/12 France
52 Mango Fruit $3,663 3/30/12 Australia
53 Apple Fruit $6,331 4/1/12 France
54 Apple Fruit $4,364 4/1/12 Canada
55 Carrots Vegetables $607 4/3/12 United Kingdom
56 Banana Fruit $1,054 4/6/12 New Zealand
57 Carrots Vegetables $7,659 4/6/12 United States
58 Broccoli Vegetables $277 4/12/12 Germany
59 Banana Fruit $235 4/17/12 United States
60 Orange Fruit $1,113 4/18/12 Australia
61 Apple Fruit $1,128 4/21/12 United States
62 Broccoli Vegetables $9,231 4/22/12 Canada
63 Banana Fruit $4,387 4/23/12 United States
64 Apple Fruit $2,763 4/25/12 Canada
65 Banana Fruit $7,898 4/27/12 United Kingdom
66 Banana Fruit $2,427 4/30/12 France
67 Banana Fruit $8,663 5/1/12 New Zealand
68 Carrots Vegetables $2,789 5/1/12 Germany
69 Banana Fruit $4,054 5/2/12 United States
70 Mango Fruit $2,262 5/2/12 United States
71 Mango Fruit $5,600 5/2/12 United Kingdom
72 Banana Fruit $5,787 5/3/12 United States
73 Orange Fruit $6,295 5/3/12 Canada
74 Banana Fruit $474 5/5/12 Germany
75 Apple Fruit $4,325 5/5/12 France
76 Banana Fruit $592 5/6/12 United States
77 Orange Fruit $4,330 5/8/12 United States
78 Banana Fruit $9,405 5/8/12 United Kingdom
79 Apple Fruit $7,671 5/8/12 France
80 Carrots Vegetables $5,791 5/8/12 United Kingdom
81 Banana Fruit $6,007 5/12/12 Canada
82 Banana Fruit $5,030 5/14/12 Germany
83 Carrots Vegetables $6,763 5/14/12 United Kingdom
84 Banana Fruit $4,248 5/15/12 Australia
85 Banana Fruit $9,543 5/16/12 France
86 Broccoli Vegetables $2,054 5/16/12 United Kingdom
87 Beans Vegetables $7,094 5/16/12 Germany
88 Carrots Vegetables $6,087 5/18/12 United States
89 Apple Fruit $4,264 5/19/12 Australia
90 Mango Fruit $9,333 5/20/12 United States
91 Mango Fruit $8,775 5/22/12 Germany
92 Broccoli Vegetables $2,011 5/23/12 United Kingdom
93 Banana Fruit $5,632 5/25/12 United States
94 Banana Fruit $4,904 5/25/12 New Zealand
95 Beans Vegetables $1,002 5/25/12 Australia
96 Orange Fruit $8,141 5/26/12 United Kingdom
97 Orange Fruit $3,644 5/26/12 Canada
98 Orange Fruit $1,380 5/26/12 Australia
99 Broccoli Vegetables $8,354 5/26/12 Germany
100 Banana Fruit $5,182 5/27/12 United States
101 Apple Fruit $2,193 5/27/12 France
102 Mango Fruit $3,647 5/28/12 United States
103 Apple Fruit $4,104 5/28/12 United States
104 Carrots Vegetables $7,457 5/28/12 United States
105 Mango Fruit $3,767 5/29/12 Canada
106 Broccoli Vegetables $4,685 5/30/12 Germany
107 Banana Fruit $3,917 6/4/12 United States
108 Apple Fruit $521 6/4/12 Canada
109 Apple Fruit $5,605 6/10/12 France
110 Broccoli Vegetables $9,630 6/11/12 Germany
111 Banana Fruit $6,941 6/20/12 Canada
112 Broccoli Vegetables $7,231 6/20/12 United Kingdom
113 Broccoli Vegetables $8,891 6/23/12 Australia
114 Banana Fruit $107 6/25/12 France
115 Banana Fruit $4,243 6/26/12 United States
116 Orange Fruit $4,514 6/27/12 United States
117 Mango Fruit $5,480 7/2/12 United States
118 Banana Fruit $5,002 7/2/12 France
119 Banana Fruit $8,530 7/5/12 Canada
120 Orange Fruit $4,819 7/7/12 New Zealand
121 Broccoli Vegetables $6,343 7/11/12 United Kingdom
122 Orange Fruit $2,318 7/13/12 United Kingdom
123 Orange Fruit $220 7/20/12 United Kingdom
124 Orange Fruit $6,341 7/20/12 New Zealand
125 Apple Fruit $330 7/20/12 Germany
126 Broccoli Vegetables $3,027 7/20/12 United Kingdom
127 Orange Fruit $850 7/22/12 New Zealand
128 Banana Fruit $8,986 7/23/12 United Kingdom
129 Broccoli Vegetables $3,800 7/25/12 United States
130 Carrots Vegetables $5,751 7/28/12 United Kingdom
131 Apple Fruit $1,704 7/29/12 United Kingdom
132 Banana Fruit $7,966 7/30/12 Australia
133 Banana Fruit $852 7/31/12 United States
134 Beans Vegetables $8,416 7/31/12 Australia
135 Banana Fruit $7,144 8/1/12 France
136 Broccoli Vegetables $7,854 8/1/12 United States
137 Orange Fruit $859 8/3/12 United States
138 Broccoli Vegetables $8,049 8/12/12 United States
139 Banana Fruit $2,836 8/13/12 Germany
140 Carrots Vegetables $1,743 8/19/12 United States
141 Apple Fruit $3,844 8/23/12 France
142 Apple Fruit $7,490 8/24/12 France
143 Broccoli Vegetables $4,483 8/25/12 Germany
144 Apple Fruit $7,333 8/27/12 Canada
145 Carrots Vegetables $7,654 8/28/12 United States
146 Apple Fruit $3,944 8/29/12 United Kingdom
147 Beans Vegetables $5,761 8/29/12 Germany
148 Banana Fruit $6,864 9/1/12 New Zealand
149 Banana Fruit $4,016 9/1/12 Germany
150 Banana Fruit $1,841 9/2/12 United States
151 Banana Fruit $424 9/5/12 Australia
152 Banana Fruit $8,765 9/7/12 United Kingdom
153 Banana Fruit $5,583 9/8/12 United States
154 Broccoli Vegetables $4,390 9/9/12 New Zealand
155 Broccoli Vegetables $352 9/9/12 Canada
156 Apple Fruit $8,489 9/11/12 United States
157 Banana Fruit $7,090 9/11/12 France
158 Banana Fruit $7,880 9/15/12 United States
159 Orange Fruit $3,861 9/18/12 United States
160 Broccoli Vegetables $7,927 9/19/12 Germany
161 Banana Fruit $6,162 9/20/12 United States
162 Mango Fruit $5,523 9/25/12 Australia
163 Broccoli Vegetables $5,936 9/25/12 United Kingdom
164 Carrots Vegetables $7,251 9/26/12 Germany
165 Orange Fruit $6,187 9/27/12 Australia
166 Banana Fruit $3,210 9/29/12 Germany
167 Carrots Vegetables $682 9/29/12 Germany
168 Banana Fruit $793 10/3/12 Australia
169 Carrots Vegetables $5,346 10/4/12 Germany
170 Banana Fruit $7,103 10/7/12 New Zealand
171 Carrots Vegetables $4,603 10/10/12 United States
172 Apple Fruit $8,160 10/16/12 France
173 Apple Fruit $7,171 10/23/12 United Kingdom
174 Banana Fruit $3,552 10/23/12 New Zealand
175 Banana Fruit $7,273 10/25/12 Australia
176 Banana Fruit $2,402 10/26/12 Germany
177 Banana Fruit $1,197 10/26/12 Australia
178 Beans Vegetables $5,015 10/26/12 Australia
179 Orange Fruit $5,818 11/2/12 United States
180 Banana Fruit $4,399 11/3/12 United Kingdom
181 Carrots Vegetables $3,011 11/3/12 United States
182 Apple Fruit $4,715 11/9/12 United Kingdom
183 Apple Fruit $5,321 11/12/12 France
184 Banana Fruit $8,894 11/15/12 United States
185 Carrots Vegetables $4,846 11/25/12 United Kingdom
186 Broccoli Vegetables $284 11/25/12 Germany
187 Orange Fruit $8,283 11/26/12 United Kingdom
188 Orange Fruit $9,990 11/28/12 Canada
189 Banana Fruit $9,014 11/28/12 Australia
190 Apple Fruit $1,942 11/29/12 France
191 Banana Fruit $7,223 11/30/12 United States
192 Carrots Vegetables $4,673 12/2/12 United States
193 Carrots Vegetables $9,104 12/4/12 France
194 Apple Fruit $6,078 12/5/12 United States
195 Beans Vegetables $3,278 12/6/12 Germany
196 Banana Fruit $136 12/12/12 Canada
197 Banana Fruit $8,377 12/12/12 Australia
198 Banana Fruit $2,382 12/12/12 United States
199 Banana Fruit $8,702 12/15/12 Germany
200 Banana Fruit $5,021 12/16/12 United States
201 Apple Fruit $1,760 12/16/12 Australia
202 Banana Fruit $4,766 12/18/12 Germany
203 Beans Vegetables $1,541 12/19/12 United Kingdom
204 Orange Fruit $2,782 12/20/12 United Kingdom
205 Apple Fruit $2,455 12/20/12 Canada
206 Apple Fruit $4,512 12/22/12 New Zealand
207 Apple Fruit $8,752 12/22/12 Germany
208 Carrots Vegetables $9,127 12/25/12 United States
209 Apple Fruit $1,777 12/28/12 France
210 Beans Vegetables $680 12/28/12 France
211 Orange Fruit $958 12/29/12 United States
212 Carrots Vegetables $2,613 12/29/12 Australia
213 Carrots Vegetables $339 12/30/12 Australia

Pivot Table

Order ID Product Category Amount Date Country
1 Carrots Vegetables $4,270 1/6/12 United States
2 Broccoli Vegetables $8,239 1/7/12 United Kingdom
3 Banana Fruit $617 1/8/12 United States
4 Banana Fruit $8,384 1/10/12 Canada
5 Beans Vegetables $2,626 1/10/12 Germany
6 Orange Fruit $3,610 1/11/12 United States
7 Broccoli Vegetables $9,062 1/11/12 Australia
8 Banana Fruit $6,906 1/16/12 New Zealand
9 Apple Fruit $2,417 1/16/12 France
10 Apple Fruit $7,431 1/16/12 Canada
11 Banana Fruit $8,250 1/16/12 Germany
12 Broccoli Vegetables $7,012 1/18/12 United States
13 Carrots Vegetables $1,903 1/20/12 Germany
14 Broccoli Vegetables $2,824 1/22/12 Canada
15 Apple Fruit $6,946 1/24/12 France
16 Banana Fruit $2,320 1/27/12 United Kingdom
17 Banana Fruit $2,116 1/28/12 United States
18 Banana Fruit $1,135 1/30/12 United Kingdom
19 Broccoli Vegetables $3,595 1/30/12 United Kingdom
20 Apple Fruit $1,161 2/2/12 United States
21 Orange Fruit $2,256 2/4/12 France
22 Banana Fruit $1,004 2/11/12 New Zealand
23 Banana Fruit $3,642 2/14/12 Canada
24 Banana Fruit $4,582 2/17/12 United States
25 Beans Vegetables $3,559 2/17/12 United Kingdom
26 Carrots Vegetables $5,154 2/17/12 Australia
27 Mango Fruit $7,388 2/18/12 France
28 Beans Vegetables $7,163 2/18/12 United States
29 Beans Vegetables $5,101 2/20/12 Germany
30 Apple Fruit $7,602 2/21/12 France
31 Mango Fruit $1,641 2/22/12 United States
32 Apple Fruit $8,892 2/23/12 Australia
33 Apple Fruit $2,060 2/29/12 France
34 Broccoli Vegetables $1,557 2/29/12 Germany
35 Apple Fruit $6,509 3/1/12 France
36 Apple Fruit $5,718 3/4/12 Australia
37 Apple Fruit $7,655 3/5/12 United States
38 Carrots Vegetables $9,116 3/5/12 United Kingdom
39 Banana Fruit $2,795 3/15/12 United States
40 Banana Fruit $5,084 3/15/12 United States
41 Carrots Vegetables $8,941 3/15/12 United Kingdom
42 Broccoli Vegetables $5,341 3/16/12 France
43 Banana Fruit $135 3/19/12 Canada
44 Banana Fruit $9,400 3/19/12 Australia
45 Beans Vegetables $6,045 3/21/12 Germany
46 Apple Fruit $5,820 3/22/12 New Zealand
47 Orange Fruit $8,887 3/23/12 Germany
48 Orange Fruit $6,982 3/24/12 United States
49 Banana Fruit $4,029 3/26/12 Australia
50 Carrots Vegetables $3,665 3/26/12 Germany
51 Banana Fruit $4,781 3/29/12 France
52 Mango Fruit $3,663 3/30/12 Australia
53 Apple Fruit $6,331 4/1/12 France
54 Apple Fruit $4,364 4/1/12 Canada
55 Carrots Vegetables $607 4/3/12 United Kingdom
56 Banana Fruit $1,054 4/6/12 New Zealand
57 Carrots Vegetables $7,659 4/6/12 United States
58 Broccoli Vegetables $277 4/12/12 Germany
59 Banana Fruit $235 4/17/12 United States
60 Orange Fruit $1,113 4/18/12 Australia
61 Apple Fruit $1,128 4/21/12 United States
62 Broccoli Vegetables $9,231 4/22/12 Canada
63 Banana Fruit $4,387 4/23/12 United States
64 Apple Fruit $2,763 4/25/12 Canada
65 Banana Fruit $7,898 4/27/12 United Kingdom
66 Banana Fruit $2,427 4/30/12 France
67 Banana Fruit $8,663 5/1/12 New Zealand
68 Carrots Vegetables $2,789 5/1/12 Germany
69 Banana Fruit $4,054 5/2/12 United States
70 Mango Fruit $2,262 5/2/12 United States
71 Mango Fruit $5,600 5/2/12 United Kingdom
72 Banana Fruit $5,787 5/3/12 United States
73 Orange Fruit $6,295 5/3/12 Canada
74 Banana Fruit $474 5/5/12 Germany
75 Apple Fruit $4,325 5/5/12 France
76 Banana Fruit $592 5/6/12 United States
77 Orange Fruit $4,330 5/8/12 United States
78 Banana Fruit $9,405 5/8/12 United Kingdom
79 Apple Fruit $7,671 5/8/12 France
80 Carrots Vegetables $5,791 5/8/12 United Kingdom
81 Banana Fruit $6,007 5/12/12 Canada
82 Banana Fruit $5,030 5/14/12 Germany
83 Carrots Vegetables $6,763 5/14/12 United Kingdom
84 Banana Fruit $4,248 5/15/12 Australia
85 Banana Fruit $9,543 5/16/12 France
86 Broccoli Vegetables $2,054 5/16/12 United Kingdom
87 Beans Vegetables $7,094 5/16/12 Germany
88 Carrots Vegetables $6,087 5/18/12 United States
89 Apple Fruit $4,264 5/19/12 Australia
90 Mango Fruit $9,333 5/20/12 United States
91 Mango Fruit $8,775 5/22/12 Germany
92 Broccoli Vegetables $2,011 5/23/12 United Kingdom
93 Banana Fruit $5,632 5/25/12 United States
94 Banana Fruit $4,904 5/25/12 New Zealand
95 Beans Vegetables $1,002 5/25/12 Australia
96 Orange Fruit $8,141 5/26/12 United Kingdom
97 Orange Fruit $3,644 5/26/12 Canada
98 Orange Fruit $1,380 5/26/12 Australia
99 Broccoli Vegetables $8,354 5/26/12 Germany
100 Banana Fruit $5,182 5/27/12 United States
101 Apple Fruit $2,193 5/27/12 France
102 Mango Fruit $3,647 5/28/12 United States
103 Apple Fruit $4,104 5/28/12 United States
104 Carrots Vegetables $7,457 5/28/12 United States
105 Mango Fruit $3,767 5/29/12 Canada
106 Broccoli Vegetables $4,685 5/30/12 Germany
107 Banana Fruit $3,917 6/4/12 United States
108 Apple Fruit $521 6/4/12 Canada
109 Apple Fruit $5,605 6/10/12 France
110 Broccoli Vegetables $9,630 6/11/12 Germany
111 Banana Fruit $6,941 6/20/12 Canada
112 Broccoli Vegetables $7,231 6/20/12 United Kingdom
113 Broccoli Vegetables $8,891 6/23/12 Australia
114 Banana Fruit $107 6/25/12 France
115 Banana Fruit $4,243 6/26/12 United States
116 Orange Fruit $4,514 6/27/12 United States
117 Mango Fruit $5,480 7/2/12 United States
118 Banana Fruit $5,002 7/2/12 France
119 Banana Fruit $8,530 7/5/12 Canada
120 Orange Fruit $4,819 7/7/12 New Zealand
121 Broccoli Vegetables $6,343 7/11/12 United Kingdom
122 Orange Fruit $2,318 7/13/12 United Kingdom
123 Orange Fruit $220 7/20/12 United Kingdom
124 Orange Fruit $6,341 7/20/12 New Zealand
125 Apple Fruit $330 7/20/12 Germany
126 Broccoli Vegetables $3,027 7/20/12 United Kingdom
127 Orange Fruit $850 7/22/12 New Zealand
128 Banana Fruit $8,986 7/23/12 United Kingdom
129 Broccoli Vegetables $3,800 7/25/12 United States
130 Carrots Vegetables $5,751 7/28/12 United Kingdom
131 Apple Fruit $1,704 7/29/12 United Kingdom
132 Banana Fruit $7,966 7/30/12 Australia
133 Banana Fruit $852 7/31/12 United States
134 Beans Vegetables $8,416 7/31/12 Australia
135 Banana Fruit $7,144 8/1/12 France
136 Broccoli Vegetables $7,854 8/1/12 United States
137 Orange Fruit $859 8/3/12 United States
138 Broccoli Vegetables $8,049 8/12/12 United States
139 Banana Fruit $2,836 8/13/12 Germany
140 Carrots Vegetables $1,743 8/19/12 United States
141 Apple Fruit $3,844 8/23/12 France
142 Apple Fruit $7,490 8/24/12 France
143 Broccoli Vegetables $4,483 8/25/12 Germany
144 Apple Fruit $7,333 8/27/12 Canada
145 Carrots Vegetables $7,654 8/28/12 United States
146 Apple Fruit $3,944 8/29/12 United Kingdom
147 Beans Vegetables $5,761 8/29/12 Germany
148 Banana Fruit $6,864 9/1/12 New Zealand
149 Banana Fruit $4,016 9/1/12 Germany
150 Banana Fruit $1,841 9/2/12 United States
151 Banana Fruit $424 9/5/12 Australia
152 Banana Fruit $8,765 9/7/12 United Kingdom
153 Banana Fruit $5,583 9/8/12 United States
154 Broccoli Vegetables $4,390 9/9/12 New Zealand
155 Broccoli Vegetables $352 9/9/12 Canada
156 Apple Fruit $8,489 9/11/12 United States
157 Banana Fruit $7,090 9/11/12 France
158 Banana Fruit $7,880 9/15/12 United States
159 Orange Fruit $3,861 9/18/12 United States
160 Broccoli Vegetables $7,927 9/19/12 Germany
161 Banana Fruit $6,162 9/20/12 United States
162 Mango Fruit $5,523 9/25/12 Australia
163 Broccoli Vegetables $5,936 9/25/12 United Kingdom
164 Carrots Vegetables $7,251 9/26/12 Germany
165 Orange Fruit $6,187 9/27/12 Australia
166 Banana Fruit $3,210 9/29/12 Germany
167 Carrots Vegetables $682 9/29/12 Germany
168 Banana Fruit $793 10/3/12 Australia
169 Carrots Vegetables $5,346 10/4/12 Germany
170 Banana Fruit $7,103 10/7/12 New Zealand
171 Carrots Vegetables $4,603 10/10/12 United States
172 Apple Fruit $8,160 10/16/12 France
173 Apple Fruit $7,171 10/23/12 United Kingdom
174 Banana Fruit $3,552 10/23/12 New Zealand
175 Banana Fruit $7,273 10/25/12 Australia
176 Banana Fruit $2,402 10/26/12 Germany
177 Banana Fruit $1,197 10/26/12 Australia
178 Beans Vegetables $5,015 10/26/12 Australia
179 Orange Fruit $5,818 11/2/12 United States
180 Banana Fruit $4,399 11/3/12 United Kingdom
181 Carrots Vegetables $3,011 11/3/12 United States
182 Apple Fruit $4,715 11/9/12 United Kingdom
183 Apple Fruit $5,321 11/12/12 France
184 Banana Fruit $8,894 11/15/12 United States
185 Carrots Vegetables $4,846 11/25/12 United Kingdom
186 Broccoli Vegetables $284 11/25/12 Germany
187 Orange Fruit $8,283 11/26/12 United Kingdom
188 Orange Fruit $9,990 11/28/12 Canada
189 Banana Fruit $9,014 11/28/12 Australia
190 Apple Fruit $1,942 11/29/12 France
191 Banana Fruit $7,223 11/30/12 United States
192 Carrots Vegetables $4,673 12/2/12 United States
193 Carrots Vegetables $9,104 12/4/12 France
194 Apple Fruit $6,078 12/5/12 United States
195 Beans Vegetables $3,278 12/6/12 Germany
196 Banana Fruit $136 12/12/12 Canada
197 Banana Fruit $8,377 12/12/12 Australia
198 Banana Fruit $2,382 12/12/12 United States
199 Banana Fruit $8,702 12/15/12 Germany
200 Banana Fruit $5,021 12/16/12 United States
201 Apple Fruit $1,760 12/16/12 Australia
202 Banana Fruit $4,766 12/18/12 Germany
203 Beans Vegetables $1,541 12/19/12 United Kingdom
204 Orange Fruit $2,782 12/20/12 United Kingdom
205 Apple Fruit $2,455 12/20/12 Canada
206 Apple Fruit $4,512 12/22/12 New Zealand
207 Apple Fruit $8,752 12/22/12 Germany
208 Carrots Vegetables $9,127 12/25/12 United States
209 Apple Fruit $1,777 12/28/12 France
210 Beans Vegetables $680 12/28/12 France
211 Orange Fruit $958 12/29/12 United States
212 Carrots Vegetables $2,613 12/29/12 Australia
213 Carrots Vegetables $339 12/30/12 Australia