For the data set below Sort the data at two levels by units sold, Low to high, and Item Description in ascending order (alphabetical order) ID Store No Sales Region Item No Item Description Unit Price Units Sold Week Ending 62 6 East 2005 24 Monitor 229 85 November 63 6 East 2005 24 Monitor 229 56 December 25 3 South 2005 24 Monitor 229 38 October 74 7 East 2005 24 Monitor 229 36 November 75 7 East 2005 24 Monitor 229 35 December 73 7 East 2005 24 Monitor 229 34 October 2 1 South 2005 24 Monitor 229 30 November 26 3 South 2005 24 Monitor 229 30 November 1 1 South 2005 24 Monitor 229 28 October 49 5 North 2005 24 Monitor 229 27 October 50 5 North 2005 24 Monitor 229 25 November 61 6 East 2005 24 Monitor 229 24 October 51 5 North 2005 24 Monitor 229 23 December 87 8 East 2005 24 Monitor 229 23 December 38 4 North 2005 24 Monitor 229 20 November 37 4 North 2005 24 Monitor 229 18 October 85 8 East 2005 24 Monitor 229 18 October 86 8 East 2005 24 Monitor 229 17 November 15 2 South 2005 24 Monitor 229 10 December 3 1 South 2005 24 Monitor 229 9 December 13 2 South 2005 24 Monitor 229 8 October 14 2 South 2005 24 Monitor 229 8 November 39 4 North 2005 24 Monitor 229 4 December 27 3 South 2005 24 Monitor 229 3 December 53 5 North 3006 Wireless Keyboard 19 95 82 November 52 5 North 3006 Wireless Keyboard 19 95 80 October 54 5 North 3006 Wireless Keyboard 19 95 75 December 66 6 East 3006 Wireless Keyboard 19 95 69 December 65 6 East 3006 Wireless Keyboard 19 95 58 November 64 6 East 3006 Wireless Keyboard 19 95 52 October 76 7 East 3006 Wireless Keyboard 19 95 49 October 78 7 East 3006 Wireless Keyboard 19 95 48 December 77 7 East 3006 Wireless Keyboard 19 95 47 November 6 1 South 3006 Wireless Keyboard 19 95 39 December 42 4 North 3006 Wireless Keyboard 19 95 36 December 5 1 South 3006 Wireless Keyboard 19 95 35 November 30 3 South 3006 Wireless Keyboard 19 95 33 December 29 3 South 3006 Wireless Keyboard 19 95 32 November 4 1 South 3006 Wireless Keyboard 19 95 30 October 28 3 South 3006 Wireless Keyboard 19 95 30 October 41 4 North 3006 Wireless Keyboard 19 95 24 November 88 8 East 3006 Wireless Keyboard 19 95 22 October 90 8 East 3006 Wireless Keyboard 19 95 22 December 89 8 East 3006 Wireless Keyboard 19 95 18 November 40 4 North 3006 Wireless Keyboard 19 95 12 October 16 2 South 3006 Wireless Keyboard 19 95 8 October 17 2 South 3006 Wireless Keyboard 19 95 8 November 18 2 South 3006 Wireless Keyboard 19 95 8 December 55 5 North 6050 PC Mouse 8 95 65 October 57 5 North 6050 PC Mouse 8 95 55 December 79 7 East 6050 PC Mouse 8 95 45 October 81 7 East 6050 PC Mouse 8 95 45 December 69 6 East 6050 PC Mouse 8 95 44 December 80 7 East 6050 PC Mouse 8 95 42 November 68 6 East 6050 PC Mouse 8 95 39 November 9 1 South 6050 PC Mouse 8 95 38 December 45 4 North 6050 PC Mouse 8 95 38 December 67 6 East 6050 PC Mouse 8 95 35 October 43 4 North 6050 PC Mouse 8 95 29 October 7 1 South 6050 PC Mouse 8 95 28 October 33 3 South 6050 PC Mouse 8 95 26 December 31 3 South 6050 PC Mouse 8 95 25 October 56 5 North 6050 PC Mouse 8 95 24 November 93 8 East 6050 PC Mouse 8 95 17 December 92 8 East 6050 PC Mouse 8 95 16 November 91 8 East 6050 PC Mouse 8 95 14 October 44 4 North 6050 PC Mouse 8 95 11 November 19 2 South 6050 PC Mouse 8 95 9 October 20 2 South 6050 PC Mouse 8 95 9 November 21 2 South 6050 PC Mouse 8 95 8 December 32 3 South 6050 PC Mouse 8 95 5 November 8 1 South 6050 PC Mouse 8 95 3 November 72 6 East 8500 Laptop 849 95 99 December 71 6 East 8500 Laptop 849 95 88 November 70 6 East 8500 Laptop 849 95 78 October 59 5 North 8500 Laptop 849 95 57 November 83 7 East 8500 Laptop 849 95 57 November 58 5 North 8500 Laptop 849 95 55 October 82 7 East 8500 Laptop 849 95 55 October 84 7 East 8500 Laptop 849 95 55 December 60 5 North 8500 Laptop 849 95 47 December 12 1 South 8500 Laptop 849 95 33 December 94 8 East 8500 Laptop 849 95 32 October 48 4 North 8500 Laptop 849 95 30 December 96 8 East 8500 Laptop 849 95 30 December 36 3 South 8500 Laptop 849 95 29 December 34 3 South 8500 Laptop 849 95 28 October 95 8 East 8500 Laptop 849 95 28 November 11 1 South 8500 Laptop 849 95 27 November 35 3 South 8500 Laptop 849 95 27 November 10 1 South 8500 Laptop 849 95 25 October 47 4 North 8500 Laptop 849 95 24 November 46 4 North 8500 Laptop 849 95 21 October 24 2 South 8500 Laptop 849 95 20 December 22 2 South 8500 Laptop 849 95 18 October 23 2 South 8500 Laptop 849 95 18 November show how to do it like the function thank you

The Answer is in the image, click to view ...

Question: For the data set below. Sort the data at two levels by units sold, Low to high, and Item Description in ascending order (alphabetical order).

For the data set below. Sort the data at two levels by units sold, Low to high, and Item Description in ascending order (alphabetical order).

ID	Store No.	Sales Region	Item No.	Item Description	Unit Price	Units Sold	Week Ending
62	6	East	2005	24" Monitor	229	85	November
63	6	East	2005	24" Monitor	229	56	December
25	3	South	2005	24" Monitor	229	38	October
74	7	East	2005	24" Monitor	229	36	November
75	7	East	2005	24" Monitor	229	35	December
73	7	East	2005	24" Monitor	229	34	October
2	1	South	2005	24" Monitor	229	30	November
26	3	South	2005	24" Monitor	229	30	November
1	1	South	2005	24" Monitor	229	28	October
49	5	North	2005	24" Monitor	229	27	October
50	5	North	2005	24" Monitor	229	25	November
61	6	East	2005	24" Monitor	229	24	October
51	5	North	2005	24" Monitor	229	23	December
87	8	East	2005	24" Monitor	229	23	December
38	4	North	2005	24" Monitor	229	20	November
37	4	North	2005	24" Monitor	229	18	October
85	8	East	2005	24" Monitor	229	18	October
86	8	East	2005	24" Monitor	229	17	November
15	2	South	2005	24" Monitor	229	10	December
3	1	South	2005	24" Monitor	229	9	December
13	2	South	2005	24" Monitor	229	8	October
14	2	South	2005	24" Monitor	229	8	November
39	4	North	2005	24" Monitor	229	4	December
27	3	South	2005	24" Monitor	229	3	December
53	5	North	3006	Wireless Keyboard	19.95	82	November
52	5	North	3006	Wireless Keyboard	19.95	80	October
54	5	North	3006	Wireless Keyboard	19.95	75	December
66	6	East	3006	Wireless Keyboard	19.95	69	December
65	6	East	3006	Wireless Keyboard	19.95	58	November
64	6	East	3006	Wireless Keyboard	19.95	52	October
76	7	East	3006	Wireless Keyboard	19.95	49	October
78	7	East	3006	Wireless Keyboard	19.95	48	December
77	7	East	3006	Wireless Keyboard	19.95	47	November
6	1	South	3006	Wireless Keyboard	19.95	39	December
42	4	North	3006	Wireless Keyboard	19.95	36	December
5	1	South	3006	Wireless Keyboard	19.95	35	November
30	3	South	3006	Wireless Keyboard	19.95	33	December
29	3	South	3006	Wireless Keyboard	19.95	32	November
4	1	South	3006	Wireless Keyboard	19.95	30	October
28	3	South	3006	Wireless Keyboard	19.95	30	October
41	4	North	3006	Wireless Keyboard	19.95	24	November
88	8	East	3006	Wireless Keyboard	19.95	22	October
90	8	East	3006	Wireless Keyboard	19.95	22	December
89	8	East	3006	Wireless Keyboard	19.95	18	November
40	4	North	3006	Wireless Keyboard	19.95	12	October
16	2	South	3006	Wireless Keyboard	19.95	8	October
17	2	South	3006	Wireless Keyboard	19.95	8	November
18	2	South	3006	Wireless Keyboard	19.95	8	December
55	5	North	6050	PC Mouse	8.95	65	October
57	5	North	6050	PC Mouse	8.95	55	December
79	7	East	6050	PC Mouse	8.95	45	October
81	7	East	6050	PC Mouse	8.95	45	December
69	6	East	6050	PC Mouse	8.95	44	December
80	7	East	6050	PC Mouse	8.95	42	November
68	6	East	6050	PC Mouse	8.95	39	November
9	1	South	6050	PC Mouse	8.95	38	December
45	4	North	6050	PC Mouse	8.95	38	December
67	6	East	6050	PC Mouse	8.95	35	October
43	4	North	6050	PC Mouse	8.95	29	October
7	1	South	6050	PC Mouse	8.95	28	October
33	3	South	6050	PC Mouse	8.95	26	December
31	3	South	6050	PC Mouse	8.95	25	October
56	5	North	6050	PC Mouse	8.95	24	November
93	8	East	6050	PC Mouse	8.95	17	December
92	8	East	6050	PC Mouse	8.95	16	November
91	8	East	6050	PC Mouse	8.95	14	October
44	4	North	6050	PC Mouse	8.95	11	November
19	2	South	6050	PC Mouse	8.95	9	October
20	2	South	6050	PC Mouse	8.95	9	November
21	2	South	6050	PC Mouse	8.95	8	December
32	3	South	6050	PC Mouse	8.95	5	November
8	1	South	6050	PC Mouse	8.95	3	November
72	6	East	8500	Laptop	849.95	99	December
71	6	East	8500	Laptop	849.95	88	November
70	6	East	8500	Laptop	849.95	78	October
59	5	North	8500	Laptop	849.95	57	November
83	7	East	8500	Laptop	849.95	57	November
58	5	North	8500	Laptop	849.95	55	October
82	7	East	8500	Laptop	849.95	55	October
84	7	East	8500	Laptop	849.95	55	December
60	5	North	8500	Laptop	849.95	47	December
12	1	South	8500	Laptop	849.95	33	December
94	8	East	8500	Laptop	849.95	32	October
48	4	North	8500	Laptop	849.95	30	December
96	8	East	8500	Laptop	849.95	30	December
36	3	South	8500	Laptop	849.95	29	December
34	3	South	8500	Laptop	849.95	28	October
95	8	East	8500	Laptop	849.95	28	November
11	1	South	8500	Laptop	849.95	27	November
35	3	South	8500	Laptop	849.95	27	November
10	1	South	8500	Laptop	849.95	25	October
47	4	North	8500	Laptop	849.95	24	November
46	4	North	8500	Laptop	849.95	21	October
24	2	South	8500	Laptop	849.95	20	December
22	2	South	8500	Laptop	849.95	18	October
23	2	South	8500	Laptop	849.95	18	November

show how to do it like the function. thank you

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Project: Jay Stoller is a sales analyst at PCC Sport, a chain of sporting goods stores in the western United States. Jay is working on a sales report that will detail customer purchases of PCC...

Hello. Can you help with this four question problem? Case PRIVATE EQUITY CASE: MERGER CONSOLIDATION The questions below COMBINE the Ohio & Maryland PT acquisitions as if they are a single c Learning...

Kan Enterprises is a case about management accounting and control, and the problems that may arise when businesses are large, and divisions managed at a distance. The case, presented in three parts...

Tiny Tots, Inc. (TTI) is a national chain of stores selling the latest fashions in children's clothing. TTI has been experiencing rapid growth and plans to double in size in the next 2 years. To help...

I am having trouble with a portion of this project and wanted to make sure my SQL is correct. I attempted to copy my ER Diagram (would not let me paste screen shot) but have copied the project...

There are two problems due this week (each worth 35 points) as follows. Problem 1.6 (page 20) In comprehensive paragraphs, answerrequirements a to e. You will have 5 paragraphs total of four to five...

Tiny Tots, Inc. Case create table style ( styleno varchar ( 6 ) not null , vendorid varchar ( 3 ), deptid varchar ( 2 ), sdesc varchar ( 20 ), cost DECIMAL ( 5 , 2 ), retail DECIMAL ( 5 , 2 ));...

BATCH 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 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...

I need help on the Boulder Public School Case Study . There are three questions asked at the end of the case study. HBSP Product Number TCG239. Rev. Oct. 2015 THE CRIMSON PRESS CURRICULUM CENTER THE...

Select TWO companies listed in the construction sector of the Main Market of Bursa Malaysia Compute the relevant ratios for the analysis of the companies capital structure for the years 2015, 2016,...

A household appliance dealer buys microwave ovens from a manufacturer and resells them to its customers. a. The manufacturer sets a list or catalogue price of $1,500 for a microwave. The manufacturer...

Which of the following is an advantage of using cost - based transfer prices? Multiple Choice Such prices motivate the buying division to control costs. Such prices are an objective measure and easy...

Draw a class diagram and its relationship based on the following statements. You can use any UML tool/software to represent your class diagram. Do NOT copy and paste your diagram, use the attachment...