ID Category Sub-Category Region Sales Quantity Discount

449 C Y West 317.84 10 0.04

440 C Z West 531.94 9 0.02
439 C X West 453.24 14 0.13
4C Z West 507.2 6 0.09
5C X West 226.77 18 0.33
391 C Z West 689.06 8 0.48
387 C Y West 724.31 3 0.37
341 C Z West 105.75 8 0.44
319 C X West 817.68 14 0.27
292 C X West 216.56 18 0.37
269 C X West 298.44 7 0.24
260 C Y West 250.33 17 0.45
250 C Z West 711.68 16 0.43
221 C Z West 883.09 2 0.06
203 C X West 133.31 12 0.05
201 C X West 387.19 17 0.26
200 C X West 860.09 17 0.44
195 C X West 931.96 12 0.01
178 C X West 692.91 6 0.01
154 C X West 793.82 14 0.05
152 C Y West 637.16 12 0.05
151 C Z West 546.73 17 0.31
146 C X West 293.45 18 0.08
139 C Y West 747.14 15 0.27
124 C X West 698.53 15 0.34
112 C X West 618.86 5 0.3
86 C X West 468.47 8 0.21
ID Category Sub-Category Region Sales Quantity Discount
421 B X East 928.76 11 0.13
420 B X East 129.27 3 0.16
413 B X East 881.76 9 0.15
410 B X East 525.89 2 0.19
325 B X East 727.72 3 0.21
43 B X East 435.98 1 0.43
246 B X East 116.09 19 0.35
71 B X East 111.7 12 0.4
197 B X East 949.84 15 0.09
367 B X North 141.17 12 0.05
357 B X North 192.26 12 0.14
326 B X North 712.13 10 0.07
285 B X North 301.44 10 0.31
170 B X North 223.14 16 0.31
158 B X North 545.94 19 0.08
127 B X North 476.89 12 0.13
99 B X North 341.81 15 0.24
463 B X South 457.23 2 0.45
423 B X South 816.88 5 0.44
373 B X South 782.44 8 0.1
310 B X South 545.63 17 0.01
251 B X South 296.43 14 0.11
70 B X South 906.7 8 0.33
225 B X South 945.16 12 0.03
183 B X South 299.09 6 0.42
109 B X South 116.55 3 0.08
457 B X West 393.82 14 0.2
26 B X West 908.25 2 0.42
27 B X West 284.63 4 0.31
295 B X West 875.91 7 0.44
72 B X West 176.96 4 0.05
76 B X West 624.74 10 0.23
94 B X West 538.69 12 0.01
103 B X West 225.42 18 0.24
461 B Y East 129.88 6 0.4
450 B Y East 988 2 0.04
23 B Y East 160.37 19 0.09
344 B Y East 983.07 4 0.38
308 B Y East 168.52 2 0.48
304 B Y East 546.29 15 0.1
271 B Y East 801.63 10 0.14
241 B Y East 419.16 11 0.49
190 B Y East 611.15 11 0.11
187 B Y East 735.02 9 0.19
 95 B Y East 905.1 5 0.13
102 B Y East 332.1 12 0.06
105 B Y East 985.96 2 0.24
106 B Y East 573.12 9 0.46
107 B Y East 254.51 5 0.26
482 B Y North 833.34 10 0.49
452 B Y North 549 4 0.43
432 B Y North 623.77 3 0.1
364 B Y North 623.95 3 0.22
305 B Y North 172.94 17 0.17
49 B Y North 744.38 12 0.47
123 B Y North 640.47 7 0.5
494 B Y South 243.59 7 0.06
453 B Y South 656.34 14 0.11
451 B Y South 228.25 1 0.17
382 B Y South 997.41 12 0.08
50 B Y South 693.03 14 0.4
280 B Y South 782.41 15 0.42
66 B Y South 457.47 3 0.22
238 B Y South 763.82 15 0.48
223 B Y South 887.23 5 0.12
176 B Y South 759 4 0.42
93 B Y South 881.62 5 0.33
398 B Y West 674.67 8 0.06
34 B Y West 507.96 10 0.25
297 B Y West 689.72 18 0.41
283 B Y West 834.25 9 0.43
278 B Y West 256.51 13 0.19
258 B Y West 520.66 18 0.32
228 B Y West 415.64 11 0.37
226 B Y West 818.9 4 0.4
196 B Y West 973.95 7 0.08
454 B Z East 732.22 1 0.18
21 B Z East 551.98 18 0.29
379 B Z East 714.97 16 0.31
35 B Z East 571.95 19 0.13
262 B Z East 308.5 4 0.39
74 B Z East 123.88 15 0.25
87 B Z East 596.84 11 0.04
118 B Z East 109.9 10 0.14
486 B Z North 835.57 15 0.49
448 B Z North 194.44 18 0.5
368 B Z North 884.38 2 0.18
335 B Z North 401.61 6 0.06
266 B Z North 561.42 10 0.07
231 B Z North 531.89 14 0.32
484 B Z South 905.33 11 0.35
10 B Z South 426.15 10 0.33
422 B Z South 654.99 15 0.41
418 B Z South 663.6 18 0.45
52 B Z South 299.77 2 0.14
156 B Z South 167.62 1 0.44
96 B Z South 819.87 17 0.13
114 B Z South 598.76 17 0.19
407 B Z West 686.5 1 0.01
28 B Z West 271.62 2 0.1
324 B Z West 853.31 18 0.42
320 B Z West 692.61 13 0.4
294 B Z West 960.09 4 0.06
237 B Z West 479.22 16 0.37
209 B Z West 405.89 14 0.3
165 B Z West 344.93 18 0.44
90 B Z West 953.61 11 0.39
97 B Z West 482.69 17 0.03
ID Category Sub-Category Region Sales Quantity Discount
13 C Z East 111.79 15 0.24
14 C Y East 697.18 1 0.09
16 A Z East 964.96 12 0.48
17 D n East 233.8 17 0.12
18 D Z East 473.16 5 0.07
20 C Z East 997.19 12 0.4
21 B Z East 551.98 18 0.29
23 B Y East 160.37 19 0.09
24 D Y East 774.96 9 0.31
33 D Z East 797.97 7 0.32
35 B Z East 571.95 19 0.13
36 A Y East 496.69 19 0.07
42 C X East 951.5 15 0.31
43 B X East 435.98 1 0.43
64 A X East 870.13 17 0.05
68 A Y East 284.49 5 0.02
71 B X East 111.7 12 0.4
74 B Z East 123.88 15 0.25
75 A Y East 263.29 11 0.19
84 D Y East 341.26 1 0.42
87 B Z East 596.84 11 0.04
88 A Z East 492.51 12 0.26
89 D Y East 365.02 1 0.45
95 B Y East 905.1 5 0.13
102 B Y East 332.1 12 0.06
104 D Z East 851.44 14 0.06
105 B Y East 985.96 2 0.24
106 B Y East 573.12 9 0.46
107 B Y East 254.51 5 0.26
108 D X East 345.08 1 0.31
110 C X East 922.87 6 0.02
111 D X East 205.98 5 0.06
117 A X East 285.78 12 0.08
118 B Z East 109.9 10 0.14
119 D Z East 223.2 18 0.46
122 A X East 637.67 18 0.01
126 D Y East 922.97 18 0.44
129 D X East 567.03 13 0.32
141 D X East 609.76 2 0.05
145 D Y East 759.31 18 0.24
147 C Y East 128.06 17 0.17
150 D Y East 146.28 8 0.37
155 A X East 195.94 4 0.29
164 D X East 725.23 2 0.1
166 A Z East 631.21 6 0.33
177 C Y East 825.91 2 0.42
181 A Z East 324.7 6 0.34
185 A X East 949.65 18 0.25
187 B Y East 735.02 9 0.19
189 C Y East 262.52 13 0.39
190 B Y East 611.15 11 0.11
191 C Z East 923.94 1 0.07
192 C X East 130.55 7 0.33
197 B X East 949.84 15 0.09
202 D X East 846.02 3 0.36
204 A Y East 636.64 6 0.11
211 C X East 158.82 2 0.16
215 C X East 386.88 8 0.37
216 A X East 663.3 16 0.49
219 D Z East 309.66 12 0.26
227 A X East 998.14 15 0.38
233 D X East 886.31 12 0.09
241 B Y East 419.16 11 0.49
242 C Z East 358.52 19 0.08
245 C Z East 137.88 13 0.29
246 B X East 116.09 19 0.35
253 D X East 807.71 3 0.23
262 B Z East 308.5 4 0.39
267 D Y East 307.6 7 0.2
268 D Z East 258.88 13 0.46
271 B Y East 801.63 10 0.14
272 D X East 415.11 10 0.02
274 D Y East 972.19 4 0.14
284 C X East 302 15 0.02
288 A Z East 622.08 16 0.16
289 A X East 182.34 17 0.39
298 C Z East 595.77 19 0.39
304 B Y East 546.29 15 0.1
308 B Y East 168.52 2 0.48
309 D Z East 866.09 1 0.09
321 D X East 865.52 2 0.27
325 B X East 727.72 3 0.21
329 D X East 242.74 17 0.05
330 D Y East 892.78 11 0.43
331 A Y East 884.66 7 0.23
336 D X East 769.16 10 0.18
337 A Y East 244.68 7 0.49
343 C X East 655.23 1 0.38
344 B Y East 983.07 4 0.38
345 C Z East 668.63 3 0.01
348 D Y East 585.99 1 0.08
349 D Z East 801.86 6 0.13
350 C Z East 196.28 9 0.47
355 D Z East 669.36 2 0.05
356 C Z East 938.83 5 0.17
361 D X East 370.87 18 0.23
362 A Y East 737.35 3 0.2
370 C Z East 971.99 17 0.14
371 D X East 774.69 3 0.16
379 B Z East 714.97 16 0.31
385 A Z East 247.26 12 0.02
386 D X East 815.33 8 0.18
392 C X East 345.93 5 0.43
397 D X East 477.75 18 0.24
402 D X East 468.4 12 0.49
403 C Y East 904.69 6 0.33
404 A Z East 306.96 2 0.06
405 D X East 291.79 14 0.34
409 D X East 877.92 13 0.1
410 B X East 525.89 2 0.19
413 B X East 881.76 9 0.15
420 B X East 129.27 3 0.16
421 B X East 928.76 11 0.13
424 C Y East 533.37 10 0.26
433 A Z East 342.09 10 0.31
436 D Y East 509.7 3 0.37
446 C Y East 135.66 18 0.08
450 B Y East 988 2 0.04
454 B Z East 732.22 1 0.18
460 C Y East 415.56 9 0.12
461 B Y East 129.88 6 0.4
470 D X East 194.11 12 0.11
473 C Z East 128.43 18 0.21
475 C Z East 146.77 11 0.24
476 D Y East 587.17 2 0.01
478 D Y East 883.87 19 0.01
480 D Y East 821.56 19 0.06
490 A X East 758.43 3 0.27
491 D Z East 173.47 9 0.32
495 A Z East 884.61 16 0.03
498 D X East 403.21 4 0.28
500 D X East 810.73 7 0.41
2D X North 507 12 0.12
6D Z North 258.75 19 0.42
 9C Y North 923.36 3 0.2
11 C Y North 622.53 19 0.18
19 D Y North 176.81 4 0.21
32 A Y North 159.14 6 0.13
37 D X North 460.69 12 0.06
40 C Z North 263.74 18 0.33
44 D Y North 343.67 3 0.2
45 D Y North 679.6 8 0.48
49 B Y North 744.38 12 0.47
51 C Z North 124.39 14 0.04
53 C Y North 307.97 5 0.47
54 D Z North 704.7 5 0.13
55 C X North 117.74 6 0.39
60 A Y North 314.36 7 0.11
63 A Y North 750.04 6 0.44
65 C Y North 847.2 2 0.49
67 D Z North 701.28 5 0.02
69 D Z North 363.83 1 0.37
77 D Y North 479.28 3 0.5
78 D Z North 903.4 14 0.49
81 C X North 333.48 10 0.18
83 A Y North 631.27 9 0.27
85 C Z North 661.73 5 0.03
99 B X North 341.81 15 0.24
113 D Z North 346.65 1 0.05
121 D Z North 886.5 2 0.25
123 B Y North 640.47 7 0.5
127 B X North 476.89 12 0.13
128 A Z North 444.82 6 0.27
134 A Y North 642.84 18 0.09
135 C Y North 320.81 1 0.03
136 A X North 450.37 8 0.16
138 A X North 420.11 5 0.13
142 A Z North 528.45 1 0.34
143 D Y North 697.3 11 0.05
153 A X North 400.82 8 0.08
157 C Y North 755.37 1 0.22
158 B X North 545.94 19 0.08
167 D X North 424.88 9 0.16
169 C X North 925.58 9 0.41
170 B X North 223.14 16 0.31
171 D Y North 955.21 13 0.34
172 A Z North 501.41 9 0.19
174 D X North 587.71 9 0.26
188 C Y North 932.72 19 0.32
194 C Y North 367.61 1 0.09
207 D Z North 169.26 8 0.24
213 A Z North 585.54 9 0.07
220 C X North 121.96 5 0.19
222 C X North 119.14 16 0.37
229 A X North 790.47 16 0.15
231 B Z North 531.89 14 0.32
234 D X North 985.68 11 0.34
239 C Z North 314.9 15 0.1
244 A X North 310.25 4 0.29
247 A Z North 988.95 2 0.46
252 A Z North 954.97 15 0.19
257 C Z North 950.26 4 0.35
261 A X North 992.05 13 0.45
263 A Z North 948.46 11 0
264 A X North 684.68 7 0.03
265 C Z North 646.96 12 0.11
266 B Z North 561.42 10 0.07
275 A Z North 895.41 7 0.14
276 D Y North 934.98 1 0.39
282 D Y North 238.51 9 0.08
285 B X North 301.44 10 0.31
290 D X North 889.71 5 0.04
296 D X North 828.56 10 0.2
299 A Z North 178.29 4 0.31
300 D X North 467.61 10 0.25
305 B Y North 172.94 17 0.17
306 A Z North 298.16 3 0.15
307 D Z North 714.93 12 0.47
314 C Y North 413.03 3 0.34
315 C X North 710.21 7 0.27
317 C X North 340.33 10 0.11
326 B X North 712.13 10 0.07
328 C Y North 777.44 9 0.11
332 A X North 126.32 14 0.37
333 D X North 843.24 19 0.15
334 C X North 215.98 4 0.39
335 B Z North 401.61 6 0.06
340 D X North 556.72 4 0.17
357 B X North 192.26 12 0.14
358 D Z North 943.51 8 0.2
364 B Y North 623.95 3 0.22
366 C X North 658.82 2 0.09
367 B X North 141.17 12 0.05
368 B Z North 884.38 2 0.18
369 C Y North 976.14 6 0.38
372 D X North 217.08 2 0.32
378 A Y North 793.37 15 0.08
381 D Y North 346.26 16 0.45
384 A X North 506.25 16 0.3
388 C Y North 298.69 16 0.41
393 D X North 955.78 8 0.06
395 C X North 489.1 1 0.16
396 D Y North 949.25 6 0.49
400 A X North 346.79 1 0.16
411 C X North 971.37 9 0.49
427 A Z North 717.01 17 0.04
431 A Y North 157.79 13 0.37
432 B Y North 623.77 3 0.1
442 D X North 362.5 3 0.05
444 D X North 874.11 2 0
448 B Z North 194.44 18 0.5
452 B Y North 549 4 0.43
455 A Z North 603.68 14 0.03
458 D Y North 565.94 3 0.38
462 A Z North 170.72 13 0.03
464 A X North 219.44 8 0.33
465 D Z North 610.79 2 0.44
471 A Y North 672.79 13 0.19
472 D Y North 735.83 14 0.06
479 A Y North 742.68 5 0.48
481 D Y North 405.51 2 0.35
482 B Y North 833.34 10 0.49
483 A Z North 172.1 2 0.41
486 B Z North 835.57 15 0.49
487 C Y North 507.09 9 0.31
489 A Y North 573.76 9 0.31
493 A Z North 322.39 19 0.11
1C Z South 763.75 19 0.11
7A Y South 548.53 5 0.36
8A X South 477.03 9 0.4
10 B Z South 426.15 10 0.33
12 C Y South 669.04 3 0.26
25 D X South 288.92 4 0.16
39 A Y South 239.72 13 0.12
41 C X South 875.61 8 0.41
46 D Z South 467.86 4 0.07
48 C Z South 240.54 10 0.33
50 B Y South 693.03 14 0.4
52 B Z South 299.77 2 0.14
 57 D Z South 819.92 9 0.25
58 A Y South 260.69 15 0.19
59 C X South 687.47 14 0.23
61 C Y South 189.5 2 0.44
62 C Y South 318.85 7 0.23
66 B Y South 457.47 3 0.22
70 B X South 906.7 8 0.33
73 A X South 287.1 13 0.02
79 C Z South 835.7 16 0.47
91 D Y South 787.25 5 0.11
92 D X South 226.1 15 0.49
93 B Y South 881.62 5 0.33
96 B Z South 819.87 17 0.13
98 D X South 120.22 12 0.48
100 A X South 587.47 15 0.45
101 C Y South 670.13 6 0.16
109 B X South 116.55 3 0.08
114 B Z South 598.76 17 0.19
115 C X South 686.28 19 0.28
116 D Y South 846.77 14 0.19
125 A X South 257.83 11 0.16
130 D Y South 142.27 16 0.11
131 D Y South 249.66 18 0.49
132 A Y South 764.23 10 0.37
140 A Y South 367.41 15 0.36
144 D Y South 943.15 10 0.48
148 C Z South 336.04 8 0.21
149 A Y South 635.57 15 0.38
156 B Z South 167.62 1 0.44
159 A Z South 719.56 16 0.28
161 C Z South 321.76 16 0.37
163 D X South 819.47 9 0.14
168 C Z South 182.42 1 0.37
173 C X South 266.62 13 0.27
175 D Z South 885.65 11 0.42
176 B Y South 759 4 0.42
180 C Y South 864.28 4 0.38
182 C Z South 540.48 19 0.38
183 B X South 299.09 6 0.42
184 C Y South 988.9 2 0.24
198 D Z South 526.79 19 0.19
199 A X South 875.84 1 0.2
205 D X South 307.01 11 0.35
206 A X South 208.51 3 0.03
208 D X South 726.66 14 0.3
210 A Y South 752.29 10 0.01
212 C Z South 383.76 14 0.32
214 C Y South 811.65 3 0.35
218 A X South 654.28 6 0.41
223 B Y South 887.23 5 0.12
224 D X South 576.04 15 0.19
225 B X South 945.16 12 0.03
235 D Z South 791.45 13 0.5
236 D X South 475.99 11 0.37
238 B Y South 763.82 15 0.48
240 D Z South 199.43 4 0.28
248 A X South 485 14 0.39
249 A X South 445.89 4 0.03
251 B X South 296.43 14 0.11
254 A X South 180.47 8 0.24
256 C Y South 891.21 10 0.47
259 D Z South 652.07 2 0.02
270 C Y South 267.79 17 0.01
273 D X South 152.06 4 0.02
277 A X South 995.42 12 0.49
280 B Y South 782.41 15 0.42
281 D Z South 726.42 13 0.13
286 C X South 583.28 10 0.28
293 A Z South 899.87 19 0.27
301 A Y South 435.42 1 0.49
303 C Z South 751.08 5 0.36
310 B X South 545.63 17 0.01
311 D X South 532.53 16 0.36
312 C Y South 633.17 5 0.21
316 D Z South 609.16 11 0.49
318 A Z South 890.77 9 0.2
323 D X South 737.53 7 0.11
327 C X South 656.75 7 0.33
338 C X South 836.17 13 0.4
339 D Z South 848.92 14 0.25
346 C X South 333.82 9 0.06
347 C X South 670.61 8 0.33
352 A X South 587.14 4 0.38
360 C Y South 161.05 8 0.19
365 C Y South 411.29 6 0.1
373 B X South 782.44 8 0.1
375 A X South 119.91 4 0.26
376 D X South 391.25 5 0.22
377 D X South 539.78 13 0.28
380 A X South 501.31 10 0.18
382 B Y South 997.41 12 0.08
383 D Z South 483.56 17 0.25
401 D Z South 985.58 16 0.5
408 D Z South 431.67 18 0.41
414 A Z South 798.94 1 0.46
415 C Z South 793.83 11 0.06
417 A X South 784.92 4 0.49
418 B Z South 663.6 18 0.45
422 B Z South 654.99 15 0.41
423 B X South 816.88 5 0.44
426 A X South 212.67 15 0.06
429 A X South 280.47 6 0.21
430 D X South 542.44 18 0.45
447 C Z South 532.46 14 0.33
451 B Y South 228.25 1 0.17
453 B Y South 656.34 14 0.11
456 C Y South 108.79 16 0.38
459 C X South 179.08 3 0.45
463 B X South 457.23 2 0.45
466 C Z South 720.52 4 0
467 D Z South 820.53 15 0.08
469 A X South 250.73 13 0.19
474 D Z South 942.59 6 0.4
484 B Z South 905.33 11 0.35
488 D X South 679.22 19 0.28
494 B Y South 243.59 7 0.06
496 C X South 297.29 16 0.13
497 C X South 978.28 1 0.02
499 A Y South 263.91 4 0.14
3A X West 302.14 18 0.11
4C Z West 507.2 6 0.09
5C X West 226.77 18 0.33
15 D Y West 260.23 7 0.19
22 A Y West 635.85 17 0.34
26 B X West 908.25 2 0.42
27 B X West 284.63 4 0.31
28 B Z West 271.62 2 0.1
29 D Y West 132.89 15 0.03
30 D Z West 524.86 2 0.02
31 A X West 608.36 4 0.19
34 B Y West 507.96 10 0.25
38 A X West 603.68 3 0.43
47 D Z West 122.85 16 0.05
56 D Y West 193.7 13 0.41
72 B X West 176.96 4 0.05
 76 B X West 624.74 10 0.23
80 D Z West 407.64 10 0.39
82 D Y West 441.72 12 0.21
86 C X West 468.47 8 0.21
90 B Z West 953.61 11 0.39
94 B X West 538.69 12 0.01
97 B Z West 482.69 17 0.03
103 B X West 225.42 18 0.24
112 C X West 618.86 5 0.3
120 A Y West 910.02 11 0.34
124 C X West 698.53 15 0.34
133 A X West 174.52 8 0.28
137 A Z West 359.82 6 0.38
139 C Y West 747.14 15 0.27
146 C X West 293.45 18 0.08
151 C Z West 546.73 17 0.31
152 C Y West 637.16 12 0.05
154 C X West 793.82 14 0.05
160 D Y West 491.34 14 0.41
162 A X West 837.19 5 0.44
165 B Z West 344.93 18 0.44
178 C X West 692.91 6 0.01
179 A Z West 723.05 14 0.37
186 A Y West 135.48 13 0.06
193 A Z West 727.68 15 0
195 C X West 931.96 12 0.01
196 B Y West 973.95 7 0.08
200 C X West 860.09 17 0.44
201 C X West 387.19 17 0.26
203 C X West 133.31 12 0.05
209 B Z West 405.89 14 0.3
217 D Z West 897.38 2 0.1
221 C Z West 883.09 2 0.06
226 B Y West 818.9 4 0.4
228 B Y West 415.64 11 0.37
230 A Z West 461.74 6 0.09
232 D X West 664.75 18 0.25
237 B Z West 479.22 16 0.37
243 D X West 366.68 15 0.35
250 C Z West 711.68 16 0.43
255 A Y West 475.82 16 0.22
258 B Y West 520.66 18 0.32
260 C Y West 250.33 17 0.45
269 C X West 298.44 7 0.24
278 B Y West 256.51 13 0.19
279 A X West 456.62 10 0.21
283 B Y West 834.25 9 0.43
287 A Y West 633.65 8 0.17
291 A Y West 339.04 4 0.12
292 C X West 216.56 18 0.37
294 B Z West 960.09 4 0.06
295 B X West 875.91 7 0.44
297 B Y West 689.72 18 0.41
302 A Z West 333.78 18 0.07
313 D Y West 842.21 15 0.04
319 C X West 817.68 14 0.27
320 B Z West 692.61 13 0.4
322 A Y West 880.56 3 0.31
324 B Z West 853.31 18 0.42
341 C Z West 105.75 8 0.44
342 D Z West 358.33 5 0.27
351 D X West 784.93 7 0.28
353 A Y West 966.69 13 0.28
354 D Y West 407.68 17 0.28
359 A Y West 719.1 6 0.4
363 A Y West 160.62 12 0.05
374 D X West 122.13 12 0.45
387 C Y West 724.31 3 0.37
389 A Y West 174.14 13 0.16
390 A Y West 712.45 19 0.4
391 C Z West 689.06 8 0.48
394 D Z West 235.95 12 0.37
398 B Y West 674.67 8 0.06
399 D Z West 457.83 7 0.36
406 D Y West 128.02 4 0.05
407 B Z West 686.5 1 0.01
412 D Y West 266.97 2 0.17
416 A X West 860.3 3 0.38
419 D Y West 218.12 6 0.33
425 D Z West 205.58 12 0.12
428 D X West 487.28 10 0.36
434 D X West 817.8 14 0.22
435 D X West 379.33 6 0.29
437 D X West 110.46 16 0.4
438 D Y West 165.2 7 0.42
439 C X West 453.24 14 0.13
440 C Z West 531.94 9 0.02
441 A X West 640.02 15 0.37
443 A Y West 725.48 2 0.16
445 D X West 801.87 3 0.34
449 C Y West 317.84 10 0.04
457 B X West 393.82 14 0.2
468 A Z West 280.14 4 0.19
477 A Y West 738.15 19 0.21
485 A Z West 592.83 18 0.42
492 A Y West 154.32 14 0.22
Count of Quantity Region
Category East North South West Total Result
A 25 36 31 30 122
B 32 21 28 27 108
C 28 30 37 27 122
D 47 38 35 28 148
Total Result 132 125 131 112 500
ID Category Sub-Category Region Sales Quantity Discount
16 A Z East 964.96 12 0.48
36 A Y East 496.69 19 0.07
64 A X East 870.13 17 0.05
68 A Y East 284.49 5 0.02
75 A Y East 263.29 11 0.19
88 A Z East 492.51 12 0.26
117 A X East 285.78 12 0.08
122 A X East 637.67 18 0.01
155 A X East 195.94 4 0.29
166 A Z East 631.21 6 0.33
181 A Z East 324.7 6 0.34
185 A X East 949.65 18 0.25
204 A Y East 636.64 6 0.11
216 A X East 663.3 16 0.49
227 A X East 998.14 15 0.38
288 A Z East 622.08 16 0.16
289 A X East 182.34 17 0.39
331 A Y East 884.66 7 0.23
337 A Y East 244.68 7 0.49
362 A Y East 737.35 3 0.2
385 A Z East 247.26 12 0.02
404 A Z East 306.96 2 0.06
433 A Z East 342.09 10 0.31
490 A X East 758.43 3 0.27
495 A Z East 884.61 16 0.03
32 A Y North 159.14 6 0.13
60 A Y North 314.36 7 0.11
63 A Y North 750.04 6 0.44
83 A Y North 631.27 9 0.27
128 A Z North 444.82 6 0.27
134 A Y North 642.84 18 0.09
136 A X North 450.37 8 0.16
138 A X North 420.11 5 0.13
142 A Z North 528.45 1 0.34
153 A X North 400.82 8 0.08
172 A Z North 501.41 9 0.19
213 A Z North 585.54 9 0.07
229 A X North 790.47 16 0.15
244 A X North 310.25 4 0.29
247 A Z North 988.95 2 0.46
252 A Z North 954.97 15 0.19
261 A X North 992.05 13 0.45
263 A Z North 948.46 11 0
264 A X North 684.68 7 0.03
275 A Z North 895.41 7 0.14
299 A Z North 178.29 4 0.31
306 A Z North 298.16 3 0.15
332 A X North 126.32 14 0.37
378 A Y North 793.37 15 0.08
384 A X North 506.25 16 0.3
400 A X North 346.79 1 0.16
427 A Z North 717.01 17 0.04
431 A Y North 157.79 13 0.37
455 A Z North 603.68 14 0.03
462 A Z North 170.72 13 0.03
464 A X North 219.44 8 0.33
471 A Y North 672.79 13 0.19
479 A Y North 742.68 5 0.48
483 A Z North 172.1 2 0.41
489 A Y North 573.76 9 0.31
493 A Z North 322.39 19 0.11
7A Y South 548.53 5 0.36
8A X South 477.03 9 0.4
39 A Y South 239.72 13 0.12
58 A Y South 260.69 15 0.19
73 A X South 287.1 13 0.02
100 A X South 587.47 15 0.45
125 A X South 257.83 11 0.16
132 A Y South 764.23 10 0.37
140 A Y South 367.41 15 0.36
149 A Y South 635.57 15 0.38
159 A Z South 719.56 16 0.28
199 A X South 875.84 1 0.2
206 A X South 208.51 3 0.03
210 A Y South 752.29 10 0.01
218 A X South 654.28 6 0.41
248 A X South 485 14 0.39
249 A X South 445.89 4 0.03
254 A X South 180.47 8 0.24
277 A X South 995.42 12 0.49
293 A Z South 899.87 19 0.27
301 A Y South 435.42 1 0.49
318 A Z South 890.77 9 0.2
352 A X South 587.14 4 0.38
375 A X South 119.91 4 0.26
380 A X South 501.31 10 0.18
414 A Z South 798.94 1 0.46
417 A X South 784.92 4 0.49
426 A X South 212.67 15 0.06
429 A X South 280.47 6 0.21
469 A X South 250.73 13 0.19
499 A Y South 263.91 4 0.14
3A X West 302.14 18 0.11
22 A Y West 635.85 17 0.34
31 A X West 608.36 4 0.19
38 A X West 603.68 3 0.43
120 A Y West 910.02 11 0.34
133 A X West 174.52 8 0.28
137 A Z West 359.82 6 0.38
162 A X West 837.19 5 0.44
179 A Z West 723.05 14 0.37
186 A Y West 135.48 13 0.06
193 A Z West 727.68 15 0
230 A Z West 461.74 6 0.09
255 A Y West 475.82 16 0.22
279 A X West 456.62 10 0.21
287 A Y West 633.65 8 0.17
291 A Y West 339.04 4 0.12
302 A Z West 333.78 18 0.07
322 A Y West 880.56 3 0.31
353 A Y West 966.69 13 0.28
359 A Y West 719.1 6 0.4
363 A Y West 160.62 12 0.05
389 A Y West 174.14 13 0.16
390 A Y West 712.45 19 0.4
416 A X West 860.3 3 0.38
441 A X West 640.02 15 0.37
443 A Y West 725.48 2 0.16
468 A Z West 280.14 4 0.19
477 A Y West 738.15 19 0.21
485 A Z West 592.83 18 0.42
492 A Y West 154.32 14 0.22
21 B Z East 551.98 18 0.29
23 B Y East 160.37 19 0.09
35 B Z East 571.95 19 0.13
43 B X East 435.98 1 0.43
71 B X East 111.7 12 0.4
74 B Z East 123.88 15 0.25
87 B Z East 596.84 11 0.04
95 B Y East 905.1 5 0.13
102 B Y East 332.1 12 0.06
105 B Y East 985.96 2 0.24
106 B Y East 573.12 9 0.46
107 B Y East 254.51 5 0.26
118 B Z East 109.9 10 0.14
187 B Y East 735.02 9 0.19
190 B Y East 611.15 11 0.11
197 B X East 949.84 15 0.09
241 B Y East 419.16 11 0.49
246 B X East 116.09 19 0.35
262 B Z East 308.5 4 0.39
271 B Y East 801.63 10 0.14
304 B Y East 546.29 15 0.1
308 B Y East 168.52 2 0.48
325 B X East 727.72 3 0.21
344 B Y East 983.07 4 0.38
379 B Z East 714.97 16 0.31
410 B X East 525.89 2 0.19
413 B X East 881.76 9 0.15
420 B X East 129.27 3 0.16
421 B X East 928.76 11 0.13
450 B Y East 988 2 0.04
454 B Z East 732.22 1 0.18
461 B Y East 129.88 6 0.4
49 B Y North 744.38 12 0.47
99 B X North 341.81 15 0.24
123 B Y North 640.47 7 0.5
127 B X North 476.89 12 0.13
158 B X North 545.94 19 0.08
170 B X North 223.14 16 0.31
231 B Z North 531.89 14 0.32
266 B Z North 561.42 10 0.07
285 B X North 301.44 10 0.31
305 B Y North 172.94 17 0.17
326 B X North 712.13 10 0.07
335 B Z North 401.61 6 0.06
357 B X North 192.26 12 0.14
364 B Y North 623.95 3 0.22
367 B X North 141.17 12 0.05
368 B Z North 884.38 2 0.18
432 B Y North 623.77 3 0.1
448 B Z North 194.44 18 0.5
452 B Y North 549 4 0.43
482 B Y North 833.34 10 0.49
486 B Z North 835.57 15 0.49
10 B Z South 426.15 10 0.33
50 B Y South 693.03 14 0.4
52 B Z South 299.77 2 0.14
66 B Y South 457.47 3 0.22
 70 B X South 906.7 8 0.33
93 B Y South 881.62 5 0.33
96 B Z South 819.87 17 0.13
109 B X South 116.55 3 0.08
114 B Z South 598.76 17 0.19
156 B Z South 167.62 1 0.44
176 B Y South 759 4 0.42
183 B X South 299.09 6 0.42
223 B Y South 887.23 5 0.12
225 B X South 945.16 12 0.03
238 B Y South 763.82 15 0.48
251 B X South 296.43 14 0.11
280 B Y South 782.41 15 0.42
310 B X South 545.63 17 0.01
373 B X South 782.44 8 0.1
382 B Y South 997.41 12 0.08
418 B Z South 663.6 18 0.45
422 B Z South 654.99 15 0.41
423 B X South 816.88 5 0.44
451 B Y South 228.25 1 0.17
453 B Y South 656.34 14 0.11
463 B X South 457.23 2 0.45
484 B Z South 905.33 11 0.35
494 B Y South 243.59 7 0.06
26 B X West 908.25 2 0.42
27 B X West 284.63 4 0.31
28 B Z West 271.62 2 0.1
34 B Y West 507.96 10 0.25
72 B X West 176.96 4 0.05
76 B X West 624.74 10 0.23
90 B Z West 953.61 11 0.39
94 B X West 538.69 12 0.01
97 B Z West 482.69 17 0.03
103 B X West 225.42 18 0.24
165 B Z West 344.93 18 0.44
196 B Y West 973.95 7 0.08
209 B Z West 405.89 14 0.3
226 B Y West 818.9 4 0.4
228 B Y West 415.64 11 0.37
237 B Z West 479.22 16 0.37
258 B Y West 520.66 18 0.32
278 B Y West 256.51 13 0.19
283 B Y West 834.25 9 0.43
294 B Z West 960.09 4 0.06
295 B X West 875.91 7 0.44
297 B Y West 689.72 18 0.41
320 B Z West 692.61 13 0.4
324 B Z West 853.31 18 0.42
398 B Y West 674.67 8 0.06
407 B Z West 686.5 1 0.01
457 B X West 393.82 14 0.2
13 C Z East 111.79 15 0.24
14 C Y East 697.18 1 0.09
20 C Z East 997.19 12 0.4
42 C X East 951.5 15 0.31
110 C X East 922.87 6 0.02
147 C Y East 128.06 17 0.17
177 C Y East 825.91 2 0.42
189 C Y East 262.52 13 0.39
191 C Z East 923.94 1 0.07
192 C X East 130.55 7 0.33
211 C X East 158.82 2 0.16
215 C X East 386.88 8 0.37
242 C Z East 358.52 19 0.08
245 C Z East 137.88 13 0.29
284 C X East 302 15 0.02
298 C Z East 595.77 19 0.39
343 C X East 655.23 1 0.38
345 C Z East 668.63 3 0.01
350 C Z East 196.28 9 0.47
356 C Z East 938.83 5 0.17
370 C Z East 971.99 17 0.14
392 C X East 345.93 5 0.43
403 C Y East 904.69 6 0.33
424 C Y East 533.37 10 0.26
446 C Y East 135.66 18 0.08
460 C Y East 415.56 9 0.12
473 C Z East 128.43 18 0.21
475 C Z East 146.77 11 0.24
9C Y North 923.36 3 0.2
11 C Y North 622.53 19 0.18
40 C Z North 263.74 18 0.33
51 C Z North 124.39 14 0.04
53 C Y North 307.97 5 0.47
55 C X North 117.74 6 0.39
65 C Y North 847.2 2 0.49
81 C X North 333.48 10 0.18
85 C Z North 661.73 5 0.03
135 C Y North 320.81 1 0.03
157 C Y North 755.37 1 0.22
169 C X North 925.58 9 0.41
188 C Y North 932.72 19 0.32
194 C Y North 367.61 1 0.09
220 C X North 121.96 5 0.19
222 C X North 119.14 16 0.37
239 C Z North 314.9 15 0.1
257 C Z North 950.26 4 0.35
265 C Z North 646.96 12 0.11
314 C Y North 413.03 3 0.34
315 C X North 710.21 7 0.27
317 C X North 340.33 10 0.11
328 C Y North 777.44 9 0.11
334 C X North 215.98 4 0.39
366 C X North 658.82 2 0.09
369 C Y North 976.14 6 0.38
388 C Y North 298.69 16 0.41
395 C X North 489.1 1 0.16
411 C X North 971.37 9 0.49
487 C Y North 507.09 9 0.31
1C Z South 763.75 19 0.11
12 C Y South 669.04 3 0.26
41 C X South 875.61 8 0.41
48 C Z South 240.54 10 0.33
59 C X South 687.47 14 0.23
61 C Y South 189.5 2 0.44
62 C Y South 318.85 7 0.23
79 C Z South 835.7 16 0.47
101 C Y South 670.13 6 0.16
115 C X South 686.28 19 0.28
148 C Z South 336.04 8 0.21
161 C Z South 321.76 16 0.37
168 C Z South 182.42 1 0.37
173 C X South 266.62 13 0.27
180 C Y South 864.28 4 0.38
182 C Z South 540.48 19 0.38
184 C Y South 988.9 2 0.24
212 C Z South 383.76 14 0.32
214 C Y South 811.65 3 0.35
256 C Y South 891.21 10 0.47
270 C Y South 267.79 17 0.01
286 C X South 583.28 10 0.28
303 C Z South 751.08 5 0.36
312 C Y South 633.17 5 0.21
327 C X South 656.75 7 0.33
338 C X South 836.17 13 0.4
346 C X South 333.82 9 0.06
347 C X South 670.61 8 0.33
360 C Y South 161.05 8 0.19
365 C Y South 411.29 6 0.1
415 C Z South 793.83 11 0.06
447 C Z South 532.46 14 0.33
456 C Y South 108.79 16 0.38
459 C X South 179.08 3 0.45
466 C Z South 720.52 4 0
496 C X South 297.29 16 0.13
497 C X South 978.28 1 0.02
4C Z West 507.2 6 0.09
5C X West 226.77 18 0.33
86 C X West 468.47 8 0.21
112 C X West 618.86 5 0.3
124 C X West 698.53 15 0.34
139 C Y West 747.14 15 0.27
146 C X West 293.45 18 0.08
151 C Z West 546.73 17 0.31
152 C Y West 637.16 12 0.05
154 C X West 793.82 14 0.05
178 C X West 692.91 6 0.01
195 C X West 931.96 12 0.01
200 C X West 860.09 17 0.44
201 C X West 387.19 17 0.26
203 C X West 133.31 12 0.05
221 C Z West 883.09 2 0.06
250 C Z West 711.68 16 0.43
260 C Y West 250.33 17 0.45
269 C X West 298.44 7 0.24
292 C X West 216.56 18 0.37
319 C X West 817.68 14 0.27
341 C Z West 105.75 8 0.44
387 C Y West 724.31 3 0.37
391 C Z West 689.06 8 0.48
439 C X West 453.24 14 0.13
440 C Z West 531.94 9 0.02
449 C Y West 317.84 10 0.04
17 D n East 233.8 17 0.12
18 D Z East 473.16 5 0.07
24 D Y East 774.96 9 0.31
33 D Z East 797.97 7 0.32
84 D Y East 341.26 1 0.42
89 D Y East 365.02 1 0.45
104 D Z East 851.44 14 0.06
108 D X East 345.08 1 0.31
111 D X East 205.98 5 0.06
119 D Z East 223.2 18 0.46
126 D Y East 922.97 18 0.44
129 D X East 567.03 13 0.32
141 D X East 609.76 2 0.05
145 D Y East 759.31 18 0.24
150 D Y East 146.28 8 0.37
164 D X East 725.23 2 0.1
202 D X East 846.02 3 0.36
219 D Z East 309.66 12 0.26
233 D X East 886.31 12 0.09
253 D X East 807.71 3 0.23
267 D Y East 307.6 7 0.2
268 D Z East 258.88 13 0.46
272 D X East 415.11 10 0.02
274 D Y East 972.19 4 0.14
309 D Z East 866.09 1 0.09
321 D X East 865.52 2 0.27
329 D X East 242.74 17 0.05
330 D Y East 892.78 11 0.43
336 D X East 769.16 10 0.18
348 D Y East 585.99 1 0.08
349 D Z East 801.86 6 0.13
355 D Z East 669.36 2 0.05
361 D X East 370.87 18 0.23
371 D X East 774.69 3 0.16
386 D X East 815.33 8 0.18
397 D X East 477.75 18 0.24
402 D X East 468.4 12 0.49
405 D X East 291.79 14 0.34
409 D X East 877.92 13 0.1
436 D Y East 509.7 3 0.37
470 D X East 194.11 12 0.11
476 D Y East 587.17 2 0.01
478 D Y East 883.87 19 0.01
480 D Y East 821.56 19 0.06
491 D Z East 173.47 9 0.32
498 D X East 403.21 4 0.28
500 D X East 810.73 7 0.41
2D X North 507 12 0.12
6D Z North 258.75 19 0.42
19 D Y North 176.81 4 0.21
37 D X North 460.69 12 0.06
44 D Y North 343.67 3 0.2
 45 D Y North 679.6 8 0.48
54 D Z North 704.7 5 0.13
67 D Z North 701.28 5 0.02
69 D Z North 363.83 1 0.37
77 D Y North 479.28 3 0.5
78 D Z North 903.4 14 0.49
113 D Z North 346.65 1 0.05
121 D Z North 886.5 2 0.25
143 D Y North 697.3 11 0.05
167 D X North 424.88 9 0.16
171 D Y North 955.21 13 0.34
174 D X North 587.71 9 0.26
207 D Z North 169.26 8 0.24
234 D X North 985.68 11 0.34
276 D Y North 934.98 1 0.39
282 D Y North 238.51 9 0.08
290 D X North 889.71 5 0.04
296 D X North 828.56 10 0.2
300 D X North 467.61 10 0.25
307 D Z North 714.93 12 0.47
333 D X North 843.24 19 0.15
340 D X North 556.72 4 0.17
358 D Z North 943.51 8 0.2
372 D X North 217.08 2 0.32
381 D Y North 346.26 16 0.45
393 D X North 955.78 8 0.06
396 D Y North 949.25 6 0.49
442 D X North 362.5 3 0.05
444 D X North 874.11 2 0
458 D Y North 565.94 3 0.38
465 D Z North 610.79 2 0.44
472 D Y North 735.83 14 0.06
481 D Y North 405.51 2 0.35
25 D X South 288.92 4 0.16
46 D Z South 467.86 4 0.07
57 D Z South 819.92 9 0.25
91 D Y South 787.25 5 0.11
92 D X South 226.1 15 0.49
98 D X South 120.22 12 0.48
116 D Y South 846.77 14 0.19
130 D Y South 142.27 16 0.11
131 D Y South 249.66 18 0.49
144 D Y South 943.15 10 0.48
163 D X South 819.47 9 0.14
175 D Z South 885.65 11 0.42
198 D Z South 526.79 19 0.19
205 D X South 307.01 11 0.35
208 D X South 726.66 14 0.3
224 D X South 576.04 15 0.19
235 D Z South 791.45 13 0.5
236 D X South 475.99 11 0.37
240 D Z South 199.43 4 0.28
259 D Z South 652.07 2 0.02
273 D X South 152.06 4 0.02
281 D Z South 726.42 13 0.13
311 D X South 532.53 16 0.36
316 D Z South 609.16 11 0.49
323 D X South 737.53 7 0.11
339 D Z South 848.92 14 0.25
376 D X South 391.25 5 0.22
377 D X South 539.78 13 0.28
383 D Z South 483.56 17 0.25
401 D Z South 985.58 16 0.5
408 D Z South 431.67 18 0.41
430 D X South 542.44 18 0.45
467 D Z South 820.53 15 0.08
474 D Z South 942.59 6 0.4
488 D X South 679.22 19 0.28
15 D Y West 260.23 7 0.19
29 D Y West 132.89 15 0.03
30 D Z West 524.86 2 0.02
47 D Z West 122.85 16 0.05
56 D Y West 193.7 13 0.41
80 D Z West 407.64 10 0.39
82 D Y West 441.72 12 0.21
160 D Y West 491.34 14 0.41
217 D Z West 897.38 2 0.1
232 D X West 664.75 18 0.25
243 D X West 366.68 15 0.35
313 D Y West 842.21 15 0.04
342 D Z West 358.33 5 0.27
351 D X West 784.93 7 0.28
354 D Y West 407.68 17 0.28
374 D X West 122.13 12 0.45
394 D Z West 235.95 12 0.37
399 D Z West 457.83 7 0.36
406 D Y West 128.02 4 0.05
412 D Y West 266.97 2 0.17
419 D Y West 218.12 6 0.33
425 D Z West 205.58 12 0.12
428 D X West 487.28 10 0.36
434 D X West 817.8 14 0.22
435 D X West 379.33 6 0.29
437 D X West 110.46 16 0.4
438 D Y West 165.2 7 0.42
445 D X West 801.87 3 0.34
(empty)
ID CategorySub-Category Region Sales Quantity Discount
1C Z South 763.75 19 0.11
2D X North 507 12 0.12
3A X West 302.14 18 0.11
4C Z West 507.2 6 0.09
5C X West 226.77 18 0.33
6D Z North 258.75 19 0.42
7A Y South 548.53 5 0.36
8A X South 477.03 9 0.4
9C Y North 923.36 3 0.2
10 B Z South 426.15 10 0.33
11 C Y North 622.53 19 0.18
12 C Y South 669.04 3 0.26
13 C Z East 111.79 15 0.24
14 C Y East 697.18 1 0.09
15 D Y West 260.23 7 0.19
16 A Z East 964.96 12 0.48
17 D n East 233.8 17 0.12
18 D Z East 473.16 5 0.07
19 D Y North 176.81 4 0.21
20 C Z East 997.19 12 0.4
21 B Z East 551.98 18 0.29
22 A Y West 635.85 17 0.34
23 B Y East 160.37 19 0.09
24 D Y East 774.96 9 0.31
25 D X South 288.92 4 0.16
26 B X West 908.25 2 0.42
27 B X West 284.63 4 0.31
28 B Z West 271.62 2 0.1
29 D Y West 132.89 15 0.03
30 D Z West 524.86 2 0.02
31 A X West 608.36 4 0.19
32 A Y North 159.14 6 0.13
33 D Z East 797.97 7 0.32
34 B Y West 507.96 10 0.25
35 B Z East 571.95 19 0.13
36 A Y East 496.69 19 0.07
37 D X North 460.69 12 0.06
38 A X West 603.68 3 0.43
39 A Y South 239.72 13 0.12
40 C Z North 263.74 18 0.33
41 C X South 875.61 8 0.41
42 C X East 951.5 15 0.31
43 B X East 435.98 1 0.43
44 D Y North 343.67 3 0.2
45 D Y North 679.6 8 0.48
46 D Z South 467.86 4 0.07
47 D Z West 122.85 16 0.05
48 C Z South 240.54 10 0.33
49 B Y North 744.38 12 0.47
50 B Y South 693.03 14 0.4
51 C Z North 124.39 14 0.04
52 B Z South 299.77 2 0.14
53 C Y North 307.97 5 0.47
54 D Z North 704.7 5 0.13
55 C X North 117.74 6 0.39
56 D Y West 193.7 13 0.41
57 D Z South 819.92 9 0.25
58 A Y South 260.69 15 0.19
59 C X South 687.47 14 0.23
60 A Y North 314.36 7 0.11
61 C Y South 189.5 2 0.44
62 C Y South 318.85 7 0.23
63 A Y North 750.04 6 0.44
64 A X East 870.13 17 0.05
65 C Y North 847.2 2 0.49
66 B Y South 457.47 3 0.22
67 D Z North 701.28 5 0.02
68 A Y East 284.49 5 0.02
69 D Z North 363.83 1 0.37
70 B X South 906.7 8 0.33
71 B X East 111.7 12 0.4
72 B X West 176.96 4 0.05
73 A X South 287.1 13 0.02
74 B Z East 123.88 15 0.25
75 A Y East 263.29 11 0.19
76 B X West 624.74 10 0.23
77 D Y North 479.28 3 0.5
78 D Z North 903.4 14 0.49
79 C Z South 835.7 16 0.47
80 D Z West 407.64 10 0.39
81 C X North 333.48 10 0.18
82 D Y West 441.72 12 0.21
83 A Y North 631.27 9 0.27
84 D Y East 341.26 1 0.42
85 C Z North 661.73 5 0.03
86 C X West 468.47 8 0.21
87 B Z East 596.84 11 0.04
88 A Z East 492.51 12 0.26
89 D Y East 365.02 1 0.45
 90 B Z West 953.61 11 0.39
91 D Y South 787.25 5 0.11
92 D X South 226.1 15 0.49
93 B Y South 881.62 5 0.33
94 B X West 538.69 12 0.01
95 B Y East 905.1 5 0.13
96 B Z South 819.87 17 0.13
97 B Z West 482.69 17 0.03
98 D X South 120.22 12 0.48
99 B X North 341.81 15 0.24
100 A X South 587.47 15 0.45
101 C Y South 670.13 6 0.16
102 B Y East 332.1 12 0.06
103 B X West 225.42 18 0.24
104 D Z East 851.44 14 0.06
105 B Y East 985.96 2 0.24
106 B Y East 573.12 9 0.46
107 B Y East 254.51 5 0.26
108 D X East 345.08 1 0.31
109 B X South 116.55 3 0.08
110 C X East 922.87 6 0.02
111 D X East 205.98 5 0.06
112 C X West 618.86 5 0.3
113 D Z North 346.65 1 0.05
114 B Z South 598.76 17 0.19
115 C X South 686.28 19 0.28
116 D Y South 846.77 14 0.19
117 A X East 285.78 12 0.08
118 B Z East 109.9 10 0.14
119 D Z East 223.2 18 0.46
120 A Y West 910.02 11 0.34
121 D Z North 886.5 2 0.25
122 A X East 637.67 18 0.01
123 B Y North 640.47 7 0.5
124 C X West 698.53 15 0.34
125 A X South 257.83 11 0.16
126 D Y East 922.97 18 0.44
127 B X North 476.89 12 0.13
128 A Z North 444.82 6 0.27
129 D X East 567.03 13 0.32
130 D Y South 142.27 16 0.11
131 D Y South 249.66 18 0.49
132 A Y South 764.23 10 0.37
133 A X West 174.52 8 0.28
134 A Y North 642.84 18 0.09
135 C Y North 320.81 1 0.03
136 A X North 450.37 8 0.16
137 A Z West 359.82 6 0.38
138 A X North 420.11 5 0.13
139 C Y West 747.14 15 0.27
140 A Y South 367.41 15 0.36
141 D X East 609.76 2 0.05
142 A Z North 528.45 1 0.34
143 D Y North 697.3 11 0.05
144 D Y South 943.15 10 0.48
145 D Y East 759.31 18 0.24
146 C X West 293.45 18 0.08
147 C Y East 128.06 17 0.17
148 C Z South 336.04 8 0.21
149 A Y South 635.57 15 0.38
150 D Y East 146.28 8 0.37
151 C Z West 546.73 17 0.31
152 C Y West 637.16 12 0.05
153 A X North 400.82 8 0.08
154 C X West 793.82 14 0.05
155 A X East 195.94 4 0.29
156 B Z South 167.62 1 0.44
157 C Y North 755.37 1 0.22
158 B X North 545.94 19 0.08
159 A Z South 719.56 16 0.28
160 D Y West 491.34 14 0.41
161 C Z South 321.76 16 0.37
162 A X West 837.19 5 0.44
163 D X South 819.47 9 0.14
164 D X East 725.23 2 0.1
165 B Z West 344.93 18 0.44
166 A Z East 631.21 6 0.33
167 D X North 424.88 9 0.16
168 C Z South 182.42 1 0.37
169 C X North 925.58 9 0.41
170 B X North 223.14 16 0.31
171 D Y North 955.21 13 0.34
172 A Z North 501.41 9 0.19
173 C X South 266.62 13 0.27
174 D X North 587.71 9 0.26
175 D Z South 885.65 11 0.42
176 B Y South 759 4 0.42
177 C Y East 825.91 2 0.42
178 C X West 692.91 6 0.01
179 A Z West 723.05 14 0.37
180 C Y South 864.28 4 0.38
181 A Z East 324.7 6 0.34
182 C Z South 540.48 19 0.38
183 B X South 299.09 6 0.42
184 C Y South 988.9 2 0.24
185 A X East 949.65 18 0.25
186 A Y West 135.48 13 0.06
187 B Y East 735.02 9 0.19
188 C Y North 932.72 19 0.32
189 C Y East 262.52 13 0.39
190 B Y East 611.15 11 0.11
191 C Z East 923.94 1 0.07
192 C X East 130.55 7 0.33
193 A Z West 727.68 15 0
194 C Y North 367.61 1 0.09
195 C X West 931.96 12 0.01
196 B Y West 973.95 7 0.08
197 B X East 949.84 15 0.09
198 D Z South 526.79 19 0.19
199 A X South 875.84 1 0.2
200 C X West 860.09 17 0.44
201 C X West 387.19 17 0.26
202 D X East 846.02 3 0.36
203 C X West 133.31 12 0.05
204 A Y East 636.64 6 0.11
205 D X South 307.01 11 0.35
206 A X South 208.51 3 0.03
207 D Z North 169.26 8 0.24
208 D X South 726.66 14 0.3
209 B Z West 405.89 14 0.3
210 A Y South 752.29 10 0.01
211 C X East 158.82 2 0.16
212 C Z South 383.76 14 0.32
213 A Z North 585.54 9 0.07
214 C Y South 811.65 3 0.35
215 C X East 386.88 8 0.37
216 A X East 663.3 16 0.49
217 D Z West 897.38 2 0.1
218 A X South 654.28 6 0.41
219 D Z East 309.66 12 0.26
220 C X North 121.96 5 0.19
221 C Z West 883.09 2 0.06
222 C X North 119.14 16 0.37
223 B Y South 887.23 5 0.12
224 D X South 576.04 15 0.19
225 B X South 945.16 12 0.03
226 B Y West 818.9 4 0.4
227 A X East 998.14 15 0.38
228 B Y West 415.64 11 0.37
229 A X North 790.47 16 0.15
230 A Z West 461.74 6 0.09
231 B Z North 531.89 14 0.32
232 D X West 664.75 18 0.25
233 D X East 886.31 12 0.09
234 D X North 985.68 11 0.34
235 D Z South 791.45 13 0.5
236 D X South 475.99 11 0.37
237 B Z West 479.22 16 0.37
238 B Y South 763.82 15 0.48
239 C Z North 314.9 15 0.1
240 D Z South 199.43 4 0.28
241 B Y East 419.16 11 0.49
242 C Z East 358.52 19 0.08
243 D X West 366.68 15 0.35
244 A X North 310.25 4 0.29
245 C Z East 137.88 13 0.29
246 B X East 116.09 19 0.35
247 A Z North 988.95 2 0.46
248 A X South 485 14 0.39
249 A X South 445.89 4 0.03
250 C Z West 711.68 16 0.43
251 B X South 296.43 14 0.11
252 A Z North 954.97 15 0.19
253 D X East 807.71 3 0.23
254 A X South 180.47 8 0.24
255 A Y West 475.82 16 0.22
256 C Y South 891.21 10 0.47
257 C Z North 950.26 4 0.35
258 B Y West 520.66 18 0.32
259 D Z South 652.07 2 0.02
260 C Y West 250.33 17 0.45
261 A X North 992.05 13 0.45
262 B Z East 308.5 4 0.39
263 A Z North 948.46 11 0
264 A X North 684.68 7 0.03
265 C Z North 646.96 12 0.11
266 B Z North 561.42 10 0.07
267 D Y East 307.6 7 0.2
268 D Z East 258.88 13 0.46
269 C X West 298.44 7 0.24
270 C Y South 267.79 17 0.01
271 B Y East 801.63 10 0.14
272 D X East 415.11 10 0.02
273 D X South 152.06 4 0.02
274 D Y East 972.19 4 0.14
275 A Z North 895.41 7 0.14
276 D Y North 934.98 1 0.39
277 A X South 995.42 12 0.49
278 B Y West 256.51 13 0.19
279 A X West 456.62 10 0.21
280 B Y South 782.41 15 0.42
281 D Z South 726.42 13 0.13
282 D Y North 238.51 9 0.08
283 B Y West 834.25 9 0.43
284 C X East 302 15 0.02
285 B X North 301.44 10 0.31
286 C X South 583.28 10 0.28
287 A Y West 633.65 8 0.17
288 A Z East 622.08 16 0.16
289 A X East 182.34 17 0.39
290 D X North 889.71 5 0.04
291 A Y West 339.04 4 0.12
292 C X West 216.56 18 0.37
293 A Z South 899.87 19 0.27
294 B Z West 960.09 4 0.06
295 B X West 875.91 7 0.44
296 D X North 828.56 10 0.2
297 B Y West 689.72 18 0.41
298 C Z East 595.77 19 0.39
299 A Z North 178.29 4 0.31
300 D X North 467.61 10 0.25
301 A Y South 435.42 1 0.49
302 A Z West 333.78 18 0.07
303 C Z South 751.08 5 0.36
304 B Y East 546.29 15 0.1
305 B Y North 172.94 17 0.17
306 A Z North 298.16 3 0.15
307 D Z North 714.93 12 0.47
308 B Y East 168.52 2 0.48
309 D Z East 866.09 1 0.09
310 B X South 545.63 17 0.01
311 D X South 532.53 16 0.36
312 C Y South 633.17 5 0.21
313 D Y West 842.21 15 0.04
314 C Y North 413.03 3 0.34
315 C X North 710.21 7 0.27
316 D Z South 609.16 11 0.49
317 C X North 340.33 10 0.11
318 A Z South 890.77 9 0.2
319 C X West 817.68 14 0.27
320 B Z West 692.61 13 0.4
321 D X East 865.52 2 0.27
322 A Y West 880.56 3 0.31
323 D X South 737.53 7 0.11
324 B Z West 853.31 18 0.42
325 B X East 727.72 3 0.21
326 B X North 712.13 10 0.07
327 C X South 656.75 7 0.33
328 C Y North 777.44 9 0.11
329 D X East 242.74 17 0.05
330 D Y East 892.78 11 0.43
331 A Y East 884.66 7 0.23
332 A X North 126.32 14 0.37
333 D X North 843.24 19 0.15
334 C X North 215.98 4 0.39
335 B Z North 401.61 6 0.06
336 D X East 769.16 10 0.18
337 A Y East 244.68 7 0.49
338 C X South 836.17 13 0.4
339 D Z South 848.92 14 0.25
340 D X North 556.72 4 0.17
341 C Z West 105.75 8 0.44
342 D Z West 358.33 5 0.27
343 C X East 655.23 1 0.38
344 B Y East 983.07 4 0.38
345 C Z East 668.63 3 0.01
346 C X South 333.82 9 0.06
347 C X South 670.61 8 0.33
348 D Y East 585.99 1 0.08
349 D Z East 801.86 6 0.13
350 C Z East 196.28 9 0.47
351 D X West 784.93 7 0.28
352 A X South 587.14 4 0.38
353 A Y West 966.69 13 0.28
354 D Y West 407.68 17 0.28
355 D Z East 669.36 2 0.05
356 C Z East 938.83 5 0.17
357 B X North 192.26 12 0.14
358 D Z North 943.51 8 0.2
359 A Y West 719.1 6 0.4
360 C Y South 161.05 8 0.19
361 D X East 370.87 18 0.23
362 A Y East 737.35 3 0.2
363 A Y West 160.62 12 0.05
364 B Y North 623.95 3 0.22
365 C Y South 411.29 6 0.1
366 C X North 658.82 2 0.09
367 B X North 141.17 12 0.05
368 B Z North 884.38 2 0.18
369 C Y North 976.14 6 0.38
370 C Z East 971.99 17 0.14
371 D X East 774.69 3 0.16
372 D X North 217.08 2 0.32
373 B X South 782.44 8 0.1
374 D X West 122.13 12 0.45
375 A X South 119.91 4 0.26
376 D X South 391.25 5 0.22
377 D X South 539.78 13 0.28
378 A Y North 793.37 15 0.08
379 B Z East 714.97 16 0.31
380 A X South 501.31 10 0.18
381 D Y North 346.26 16 0.45
382 B Y South 997.41 12 0.08
383 D Z South 483.56 17 0.25
384 A X North 506.25 16 0.3
385 A Z East 247.26 12 0.02
386 D X East 815.33 8 0.18
387 C Y West 724.31 3 0.37
388 C Y North 298.69 16 0.41
389 A Y West 174.14 13 0.16
390 A Y West 712.45 19 0.4
391 C Z West 689.06 8 0.48
392 C X East 345.93 5 0.43
393 D X North 955.78 8 0.06
394 D Z West 235.95 12 0.37
395 C X North 489.1 1 0.16
396 D Y North 949.25 6 0.49
397 D X East 477.75 18 0.24
398 B Y West 674.67 8 0.06
399 D Z West 457.83 7 0.36
400 A X North 346.79 1 0.16
401 D Z South 985.58 16 0.5
402 D X East 468.4 12 0.49
403 C Y East 904.69 6 0.33
404 A Z East 306.96 2 0.06
405 D X East 291.79 14 0.34
406 D Y West 128.02 4 0.05
407 B Z West 686.5 1 0.01
408 D Z South 431.67 18 0.41
409 D X East 877.92 13 0.1
410 B X East 525.89 2 0.19
411 C X North 971.37 9 0.49
412 D Y West 266.97 2 0.17
413 B X East 881.76 9 0.15
414 A Z South 798.94 1 0.46
415 C Z South 793.83 11 0.06
416 A X West 860.3 3 0.38
417 A X South 784.92 4 0.49
418 B Z South 663.6 18 0.45
419 D Y West 218.12 6 0.33
420 B X East 129.27 3 0.16
421 B X East 928.76 11 0.13
422 B Z South 654.99 15 0.41
423 B X South 816.88 5 0.44
424 C Y East 533.37 10 0.26
425 D Z West 205.58 12 0.12
426 A X South 212.67 15 0.06
427 A Z North 717.01 17 0.04
428 D X West 487.28 10 0.36
429 A X South 280.47 6 0.21
430 D X South 542.44 18 0.45
431 A Y North 157.79 13 0.37
432 B Y North 623.77 3 0.1
433 A Z East 342.09 10 0.31
434 D X West 817.8 14 0.22
435 D X West 379.33 6 0.29
436 D Y East 509.7 3 0.37
437 D X West 110.46 16 0.4
438 D Y West 165.2 7 0.42
439 C X West 453.24 14 0.13
440 C Z West 531.94 9 0.02
441 A X West 640.02 15 0.37
442 D X North 362.5 3 0.05
443 A Y West 725.48 2 0.16
444 D X North 874.11 2 0
445 D X West 801.87 3 0.34
446 C Y East 135.66 18 0.08
447 C Z South 532.46 14 0.33
448 B Z North 194.44 18 0.5
449 C Y West 317.84 10 0.04
450 B Y East 988 2 0.04
451 B Y South 228.25 1 0.17
452 B Y North 549 4 0.43
453 B Y South 656.34 14 0.11
454 B Z East 732.22 1 0.18
455 A Z North 603.68 14 0.03
456 C Y South 108.79 16 0.38
457 B X West 393.82 14 0.2
458 D Y North 565.94 3 0.38
459 C X South 179.08 3 0.45
460 C Y East 415.56 9 0.12
461 B Y East 129.88 6 0.4
462 A Z North 170.72 13 0.03
463 B X South 457.23 2 0.45
464 A X North 219.44 8 0.33
465 D Z North 610.79 2 0.44
466 C Z South 720.52 4 0
467 D Z South 820.53 15 0.08
468 A Z West 280.14 4 0.19
469 A X South 250.73 13 0.19
470 D X East 194.11 12 0.11
471 A Y North 672.79 13 0.19
472 D Y North 735.83 14 0.06
473 C Z East 128.43 18 0.21
474 D Z South 942.59 6 0.4
475 C Z East 146.77 11 0.24
476 D Y East 587.17 2 0.01
477 A Y West 738.15 19 0.21
478 D Y East 883.87 19 0.01
479 A Y North 742.68 5 0.48
480 D Y East 821.56 19 0.06
481 D Y North 405.51 2 0.35
482 B Y North 833.34 10 0.49
483 A Z North 172.1 2 0.41
484 B Z South 905.33 11 0.35
485 A Z West 592.83 18 0.42
486 B Z North 835.57 15 0.49
487 C Y North 507.09 9 0.31
488 D X South 679.22 19 0.28
489 A Y North 573.76 9 0.31
490 A X East 758.43 3 0.27
491 D Z East 173.47 9 0.32
492 A Y West 154.32 14 0.22
493 A Z North 322.39 19 0.11
494 B Y South 243.59 7 0.06
495 A Z East 884.61 16 0.03
496 C X South 297.29 16 0.13
497 C X South 978.28 1 0.02
498 D X East 403.21 4 0.28
499 A Y South 263.91 4 0.14
500 D X East 810.73 7 0.41
 Tasks
1. Buat pivot table untuk menghitung total penjualan (Sales) berdasarkan Category dan Region.
2. Buat pivot table untuk menghitung rata-rata diskon (Discount) untuk setiap Sub-Category dan Region.
3. Buat pivot table untuk menghitung total jumlah barang terjual (Quantity) berdasarkan Category dan Sub-Category.
4. Buat pivot table untuk menghitung penjualan rata-rata (Sales) per Region.
5. Buat pivot table untuk melihat jumlah transaksi berdasarkan Category dan Region.
ory dan Sub-Category.