Create a cross tab that shows by region and item description the number of units sold.
ID + LOCO 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 Store No. 1 1 1 1 1 1 1 1 1 1 1 1 2 2 2 2 2 2 2 2 2 2 2 Sales Region Item No. Item Description Unit Price Units Sold South 2005 24" Monitor $229.00 28 South 2005 24" Monitor $229.00 30 South 2005 24" Monitor $229.00 9 South 3006 Wireless Keyboard $19.95 30 South 3006 Wireless Keyboard $19.95 35 South 3006 Wireless Keyboard $19.95 39 South 6050 PC Mouse $8.95 28 South 6050 PC Mouse $8.95 3 South 6050 PC Mouse $8.95 38 South 8500 Laptop $849.95 25 South 8500 Laptop $849.95 27 South 8500 Laptop $849.95 33 South 2005 24" Monitor $229.00 8 South 2005 24" Monitor $229.00 8 South 2005 24" Monitor $229.00 10 South 3006 Wireless Keyboard $19.95 8 South 3006 Wireless Keyboard $19.95 8 South 3006 Wireless Keyboard $19.95 8 South 6050 PC Mouse $8.95 9 South 6050 PC Mouse $8.95 9 South 6050 PC Mouse $8.95 8 South 8500 Laptop $849.95 18 South 8500 Laptop $849.95 18 Sales Revenue $6,412.00 $6,870.00 $2,061.00 $598.50 $698.25 $778.05 $250.60 $26.85 $340.10 $21,248.75 $22,948.65 $28,048.35 $1,832.00 $1,832.00 $2,290.00 $159.60 $159.60 $159.60 $80.55 $80.55 $71.60 $15,299.10 $15,299.10 Week Ending October November December October November December October November December October November December October November December October November December October November December October November LE CO o oo 0 0 Oo oo G 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 A 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 B 2 2 3 3 3 3 3 3 3 3 3 3 3 3 4 4 4 4 4 4 4 4 4 4 South South South South South South South South South South South South South South North North North North North North North North North North D E 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop F $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 18 20 38 30 3 30 32 33 25 5 26 28 27 29 18 20 4 12 24 36 29 11 38 21 H $15,299.10 $16,999.00 $8,702.00 $6,870.00 $687.00 $598.50 $638.40 $658.35 $223.75 $44.75 $232.70 $23,798.60 $22.948.65 $24,648.55 $4, 122.00 $4,580.00 $916.00 $239.40 $478.80 $718.20 $259.55 $98.45 $340.10 $17,848.95 November December October November December October November December October November December October November December October November December October November December October November December October 41 42 43 44 45 46 47 48 49 G J K L B 4 4 4 49 50 51 52 53 54 55 56 57 58 59 5 5 5 5 5 5 5 60 61 62 63 A 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 5 5 5 5 5 North North North North North North North North North North North North North North North East East East East East East East East East D E 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse F. $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 21 24 30 27 25 23 80 82 75 65 24 55 55 57 47 24 85 56 52 58 69 35 39 44 H $17,848.95 $20,398.80 $25,498.50 $6,183.00 $5,725.00 $5,267.00 $1,596.00 $1,635.90 $1,496.25 $581.75 $214.80 $492.25 $46,747.25 $48,447.15 $39,947.65 $5,496.00 $19,465.00 $12,824.00 $1,037.40 $1,157.10 $1,376.55 $313.25 $349.05 $393.80 | October November December October November December October November December October November December October November December October November December October November December October November December 64 65 66 67 68 6 6 6 6 6 6 69 6 6 70 71 72 6 6 70 71 72 73 74 75 76 77 78 0 0 0 0 0 0 0 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 To A 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 B 6 6 6 6 6 6 7 7 7 7 7 7 7 7 7 7 7 7 8 8 East East East East East East East East East East East East East East East East East East East East East East East East 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 35 39 44 78 88 99 34 36 35 49 47 48 45 42 45 55 57 55 18 17 23 22 18 22 $313.25 $349.05 $393.80 $66,296.10 $74,795.60 $84, 145.05 $7,786.00 $8,244.00 $8,015.00 $977.55 $937.65 $957.60 $402.75 $375.90 $402.75 $46,747.25 $48,447.15 $46,747.25 $4, 122.00 $3,893.00 $5,267.00 $438.90 $359.10 $438.90 October November December October November December October November December October November December October November December October November December October November December October November December oo oo oo oo O CO 8 8 8 G COC 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 A 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 oo oo oo oo oo oo oo oo B 7 7 7 7 7 7 7 7 8 8 8 8 8 8 8 8 8 8 8 8 East East East East East East East East East East East East East East East East East East East East D E 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop 2005 24" Monitor 2005 24" Monitor 2005 24" Monitor 3006 Wireless Keyboard 3006 Wireless Keyboard 3006 Wireless Keyboard 6050 PC Mouse 6050 PC Mouse 6050 PC Mouse 8500 Laptop 8500 Laptop 8500 Laptop F $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 $229.00 $229.00 $229.00 $19.95 $19.95 $19.95 $8.95 $8.95 $8.95 $849.95 $849.95 $849.95 47 48 45 42 45 55 57 55 18 17 23 22 18 22 14 16 17 32 28 30 H $937.65 $957.60 $402.75 $375.90 $402.75 $46,747.25 $48,447.15 $46,747.25 $4,122.00 $3,893.00 $5,267.00 $438.90 $359.10 $438.90 $125.30 $143.20 $152.15 $27,198.40 $23,798.60 $25,498.50 November December October November December October November December October November December October November December October November December October November December 00 00 00 00 HBT
