B10 & fx Sum of Sales Amount D F A E G H B 1 #1 2 Hide "Row Labels" in cell A10 3 Change the header in B10 to "Sales in $s" 4 Format "Sales in $s" output as number, comma separator, zero decimals 5 Sort by Business Segment Sales in $s within each country, largest to smallest. Business Segments are Accessories, Bikes, etc. 6 When finished, your pivot table should match the image to the right 7 8 9 B 10 Row Labels Sum of Sales Amount 10 Sales in $s 11 France 4647454.207 11 e France 4,647,454 12 Accessories 48941.5643 12 Bikes 3,597,879 13 13 Bikes 3597879.394 Components 871,125 14 14 Clothing 129508.0548 Clothing 129,508 15 15 Components Accessories 871125.1938 48,942 16 Germany 2,051,548 16 Germany 2051547.729 17 1,602,487 17 Accessories 35681.4552 18 Components 337,787 18 Bikes 1602487.163 19 Clothing 75,593 19 Clothing 75592.5945 20 Accessories 35,681 20 Components 337786.516 21 United Kingdom 4,311,127 21 United Kingdom 4311126.886 22 Bikes 3,435,134 22 Accessories 43180.2218 23 Components 712,588 23 Bikes 3435134.262 24 Clothing 120,225 24 Clothing 120224.8062 25 Accessories 43,180 25 Components 712587.5956 26 Grand Total 11,010,129 26 Grand Total 11010128.82 27 28 Bikes B10 & fx Sum of Sales Amount D F A E G H B 1 #1 2 Hide "Row Labels" in cell A10 3 Change the header in B10 to "Sales in $s" 4 Format "Sales in $s" output as number, comma separator, zero decimals 5 Sort by Business Segment Sales in $s within each country, largest to smallest. Business Segments are Accessories, Bikes, etc. 6 When finished, your pivot table should match the image to the right 7 8 9 B 10 Row Labels Sum of Sales Amount 10 Sales in $s 11 France 4647454.207 11 e France 4,647,454 12 Accessories 48941.5643 12 Bikes 3,597,879 13 13 Bikes 3597879.394 Components 871,125 14 14 Clothing 129508.0548 Clothing 129,508 15 15 Components Accessories 871125.1938 48,942 16 Germany 2,051,548 16 Germany 2051547.729 17 1,602,487 17 Accessories 35681.4552 18 Components 337,787 18 Bikes 1602487.163 19 Clothing 75,593 19 Clothing 75592.5945 20 Accessories 35,681 20 Components 337786.516 21 United Kingdom 4,311,127 21 United Kingdom 4311126.886 22 Bikes 3,435,134 22 Accessories 43180.2218 23 Components 712,588 23 Bikes 3435134.262 24 Clothing 120,225 24 Clothing 120224.8062 25 Accessories 43,180 25 Components 712587.5956 26 Grand Total 11,010,129 26 Grand Total 11010128.82 27 28 Bikes