Sum of Sales Row Labels Academy Ace Hardware Bass Pro Shops Big 5 Cabela's Camping World Champs Dick's Sporting Goods Eastbay Gander Mountain Home Depot Lowes Column Labels - Mass Retail Mass Retail Total Sporting Goods Sporting Goods Total Grand Total 2013 2014 2015 2016 2017 2018 2019 2013 2014 2015 2016 2017 2018 2019 0 118101.6335 407207.3293 814271.9346 2653507.013 2562916.984 2416725.998 8972730.892 8972730.892 1570282.267 1581034.922 1808424.119 1762328.199 1878179.01 1956060.735 1741735.874 12298045.13 12298045.13 975661.7271 1595640.99 1634973.143 2022251.939 6228527.799 6228527.799 1871158.19 1616003.997 1284854.498 1694071.127 6466087.812 6466087.812 2656194.486 2671715.354 2716695.055 2687934.503 2733412.793 2660938.626 2405372.243 18532263.06 18532263.06 1373748.963 1798035.357 1630593.602 1331335.541 6133713.463 6133713.463 2425936.702 2128870.429 1883051.962 1611473.821 8049332.914 8049332.914 2989307.589 2918392.251 4215860.023 3865385.979 3598784.872 3916594.27 4344300.071 25848625.06 25848625.06 5030329.581 5748359.315 5478461.779 5249429.83 5635077.281 7046418.094 7386900.202 41574976.08 41574976.08 1022869.138 970542.2578 1156174.555 896713.2145 4046299.165 4046299.165 1002601.7 986229.9215 1631622.055 2123014.798 2692751.25 3104114.339 3213809.834 14754143.9 14754143.9 3531307.816 1945471.44 3122840.584 2132437.373 2604208.057 2716212.63 3167141.852 19219619.75 19219619.75 1304112.768 1327347.74 1622716.858 1659948.14 5914125.506 5914125.506 16070834.83 18535452.92 23412270.58 22772864.91 18580046.65 18999746.25 20316009.44 138687225.6 138687225.6 1545460.342 1412530.12 1221528.039 1218654.821 5398173.322 5398173.322 1334548.833 1527682.199 1602907.547 1898388.09 6363526.669 6363526.669 907844.8503 1188820.441 1228077.795 1221072.188 4545815.275 4545815.275 5007291.856 4622241.895 4032023.573 3874515.528 3601766.032 2928544.28 2811396.719 26877779.88 26877779.88 805442.5417 964978.8132 937200.1305 1021161.287 3728782.772 3728782.772 4141041.131 5731265.648 5402387.681 5525655.728 5734046.334 5838055.766 6505864.502 38878316.79 38878316.79 15252524.77 14866243.83 15997298.01 15417951.63 16510950.68 16542987.75 17439948.78 112027905.4 26746666.49 29992021.47 36230494.76 48956671.22 47731280.95 49388692.35 51444378.12 290490205.4 402518110.8 Orvis REI Scheels Sport Chalet Sportsman's Warehouse Target The Sports Authority Walmart Grand Total 1 To move the Distribution Channel Subtotals to the bottom of the channel, click on Design at the top of the page and select "Subtotals" located on the left at the top of the page. Next select "Show all Subtotals at Bottom of Group". 2 To sort Distribution Channels so the largest channel is reported at the top of the report, click on the "Grand Total" for the Mass Retail channel. Right click to pop up a menu and click on Sort and select Largest to Smallest. This will move Sporting Goods to the top. 3 To format the report to display just the years 2016, 2017, 2018 and 2019, click on the white box next to "Column Labels" at the top of the report in Column B. Remove the checks in the boxes for years not to be displayed. Then click OK. 4 To remove the Grand Total for the rows, click on Design at the top of the page and select "Grand Totals" located on the left at the top of the page. Next select "On for Columns Only". 5 To sort Retail Outlets highest to lowest based on 2019 results, select any Retail Outlets results in 2019 within Sporting Goods and right click. Next click on Sort and select Largest to Smallest. Repeat the same procedure for Mass Retail. 6 Final Step, select the data cells and format your financial data to insert commas with zero decimals. Your report is now complete Link answers to Report and show Excel calculations Answer the following 2 Part Questions using the Pivot Table Distribution report: Answer 1 Answer 2 1 Who is the largest retail outlet for Sporting Goods in 2019 and what are their Sales? 2 Who is the largest retail outlet for Mass Retail in 2019 and what are their Sales? 3 In 2019, how much larger are Total Sales from Sporting Goods versus Mass Retail in dollars and %? 4 In 2019, how much have Sales in Sporting Goods grown since 2018 in dollars and % 5 In 2019, how much have Sales in Mass Retail grown since 2018 in dollars and % 6 In 2019 how much have Grand Total Sales for all Segments grown since 2018 in dollars and % 7 In 2019, how much have Sales in Sporting Goods grown since 2016 in dollars and % 8 In 2019, how much have Sales in Mass Retail grown since 2016 in dollars and % 9 In 2019, how much have Grand Total Sales for Segments grown since 2016 in dollars and % 10 Bonus Point: What is the 2016-2019 CAGR% for the Total Sales from all Distribution Channels Sum of Sales Row Labels Academy Ace Hardware Bass Pro Shops Big 5 Cabela's Camping World Champs Dick's Sporting Goods Eastbay Gander Mountain Home Depot Lowes Column Labels - Mass Retail Mass Retail Total Sporting Goods Sporting Goods Total Grand Total 2013 2014 2015 2016 2017 2018 2019 2013 2014 2015 2016 2017 2018 2019 0 118101.6335 407207.3293 814271.9346 2653507.013 2562916.984 2416725.998 8972730.892 8972730.892 1570282.267 1581034.922 1808424.119 1762328.199 1878179.01 1956060.735 1741735.874 12298045.13 12298045.13 975661.7271 1595640.99 1634973.143 2022251.939 6228527.799 6228527.799 1871158.19 1616003.997 1284854.498 1694071.127 6466087.812 6466087.812 2656194.486 2671715.354 2716695.055 2687934.503 2733412.793 2660938.626 2405372.243 18532263.06 18532263.06 1373748.963 1798035.357 1630593.602 1331335.541 6133713.463 6133713.463 2425936.702 2128870.429 1883051.962 1611473.821 8049332.914 8049332.914 2989307.589 2918392.251 4215860.023 3865385.979 3598784.872 3916594.27 4344300.071 25848625.06 25848625.06 5030329.581 5748359.315 5478461.779 5249429.83 5635077.281 7046418.094 7386900.202 41574976.08 41574976.08 1022869.138 970542.2578 1156174.555 896713.2145 4046299.165 4046299.165 1002601.7 986229.9215 1631622.055 2123014.798 2692751.25 3104114.339 3213809.834 14754143.9 14754143.9 3531307.816 1945471.44 3122840.584 2132437.373 2604208.057 2716212.63 3167141.852 19219619.75 19219619.75 1304112.768 1327347.74 1622716.858 1659948.14 5914125.506 5914125.506 16070834.83 18535452.92 23412270.58 22772864.91 18580046.65 18999746.25 20316009.44 138687225.6 138687225.6 1545460.342 1412530.12 1221528.039 1218654.821 5398173.322 5398173.322 1334548.833 1527682.199 1602907.547 1898388.09 6363526.669 6363526.669 907844.8503 1188820.441 1228077.795 1221072.188 4545815.275 4545815.275 5007291.856 4622241.895 4032023.573 3874515.528 3601766.032 2928544.28 2811396.719 26877779.88 26877779.88 805442.5417 964978.8132 937200.1305 1021161.287 3728782.772 3728782.772 4141041.131 5731265.648 5402387.681 5525655.728 5734046.334 5838055.766 6505864.502 38878316.79 38878316.79 15252524.77 14866243.83 15997298.01 15417951.63 16510950.68 16542987.75 17439948.78 112027905.4 26746666.49 29992021.47 36230494.76 48956671.22 47731280.95 49388692.35 51444378.12 290490205.4 402518110.8 Orvis REI Scheels Sport Chalet Sportsman's Warehouse Target The Sports Authority Walmart Grand Total 1 To move the Distribution Channel Subtotals to the bottom of the channel, click on Design at the top of the page and select "Subtotals" located on the left at the top of the page. Next select "Show all Subtotals at Bottom of Group". 2 To sort Distribution Channels so the largest channel is reported at the top of the report, click on the "Grand Total" for the Mass Retail channel. Right click to pop up a menu and click on Sort and select Largest to Smallest. This will move Sporting Goods to the top. 3 To format the report to display just the years 2016, 2017, 2018 and 2019, click on the white box next to "Column Labels" at the top of the report in Column B. Remove the checks in the boxes for years not to be displayed. Then click OK. 4 To remove the Grand Total for the rows, click on Design at the top of the page and select "Grand Totals" located on the left at the top of the page. Next select "On for Columns Only". 5 To sort Retail Outlets highest to lowest based on 2019 results, select any Retail Outlets results in 2019 within Sporting Goods and right click. Next click on Sort and select Largest to Smallest. Repeat the same procedure for Mass Retail. 6 Final Step, select the data cells and format your financial data to insert commas with zero decimals. Your report is now complete Link answers to Report and show Excel calculations Answer the following 2 Part Questions using the Pivot Table Distribution report: Answer 1 Answer 2 1 Who is the largest retail outlet for Sporting Goods in 2019 and what are their Sales? 2 Who is the largest retail outlet for Mass Retail in 2019 and what are their Sales? 3 In 2019, how much larger are Total Sales from Sporting Goods versus Mass Retail in dollars and %? 4 In 2019, how much have Sales in Sporting Goods grown since 2018 in dollars and % 5 In 2019, how much have Sales in Mass Retail grown since 2018 in dollars and % 6 In 2019 how much have Grand Total Sales for all Segments grown since 2018 in dollars and % 7 In 2019, how much have Sales in Sporting Goods grown since 2016 in dollars and % 8 In 2019, how much have Sales in Mass Retail grown since 2016 in dollars and % 9 In 2019, how much have Grand Total Sales for Segments grown since 2016 in dollars and % 10 Bonus Point: What is the 2016-2019 CAGR% for the Total Sales from all Distribution Channels