Question: Please answer only 8.2. 30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB EXERCISE 8-7 (SEE THE CASE STUDY HANDOUT) 8.1 MAKE THE SEMESTER, QUARTER, AND
Please answer only 8.2.

30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB EXERCISE 8-7 (SEE THE CASE STUDY HANDOUT) 8.1 MAKE THE SEMESTER, QUARTER, AND MONTH VALUES UNIQUE IN THE EXCEL DISPLAY AS THE FOLLOWING: H1 2013 FOR THE FIRST SEMESTER OF 2013 Q1 2013 FOR THE FIRST QUARTER OF 2013 JANUARY 2013 FOR THE JANUARY OF 2013 Total Sales Column Labels +2010 + 2011 +2012 Row Labels + Accessories + Bikes + Clothing Grand Total 2013 H1 2013 Q1 2013 + February 2013 January 2013 March 2013 $12,587.75 $6,009.76 $16,520.54 $256,707.13 $313,576.75 $338,847.08 $5,401.45 $2,928.76 $6,844.62 $274,696.33 $322,515.27 $362,212.24 $1,080.76 $4,099.09 $1,481,936.71 $1,968,068.84 $274.89 $4,099.09 $1,481,936.71 $1,969,424.49 8.2 MAKE THE MONTHS IN THE RIGHT ORDER AS INDICATED BELOW: Total Sales GQ1 2013 Q1 2013 Total Row Labels + January 2013 February 2013 March 2013 + Accessories $19,049.71 $46, 246.09 $55,339.21 $120,635.01 + Bikes $829,911.35 $703,796.72 $967,773.46 $2,501,481.53 + Clothing $8,728.85 $21,305.93 $26,794.72 $56,829.50 Grand Total $857,689.91 $771,348.74 $1,049,907.39 $2,678,946.04 30 POINTS COMPLETE SQL TABULAR MODEL CASE LAB EXERCISE 8-7 (SEE THE CASE STUDY HANDOUT) 8.1 MAKE THE SEMESTER, QUARTER, AND MONTH VALUES UNIQUE IN THE EXCEL DISPLAY AS THE FOLLOWING: H1 2013 FOR THE FIRST SEMESTER OF 2013 Q1 2013 FOR THE FIRST QUARTER OF 2013 JANUARY 2013 FOR THE JANUARY OF 2013 Total Sales Column Labels +2010 + 2011 +2012 Row Labels + Accessories + Bikes + Clothing Grand Total 2013 H1 2013 Q1 2013 + February 2013 January 2013 March 2013 $12,587.75 $6,009.76 $16,520.54 $256,707.13 $313,576.75 $338,847.08 $5,401.45 $2,928.76 $6,844.62 $274,696.33 $322,515.27 $362,212.24 $1,080.76 $4,099.09 $1,481,936.71 $1,968,068.84 $274.89 $4,099.09 $1,481,936.71 $1,969,424.49 8.2 MAKE THE MONTHS IN THE RIGHT ORDER AS INDICATED BELOW: Total Sales GQ1 2013 Q1 2013 Total Row Labels + January 2013 February 2013 March 2013 + Accessories $19,049.71 $46, 246.09 $55,339.21 $120,635.01 + Bikes $829,911.35 $703,796.72 $967,773.46 $2,501,481.53 + Clothing $8,728.85 $21,305.93 $26,794.72 $56,829.50 Grand Total $857,689.91 $771,348.74 $1,049,907.39 $2,678,946.04
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
