Use Pivot Tables to find the number of sales transactions by product and region, total amount...

Transcribed Image Text:

Use Pivot Tables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the accompanying Sales Transactions data Click the icon to view the Sales Transactions data. Use Pivot Tables to find the number of sales transactions by product and region. (Type whole numbers.) Count of Amount Book DVD Grand Total East North South West Grand Total ELE Sales Transactions Cust ID Region Transaction Code 10001 East 94108738 10002 West 74083490 10003 North 64942368 72753924 35208817 10004 West 10005 South 10006 West 10007 East 10008 West 20978903 80321173 14132683 10009 West 40128225 10010 South 51285539 10011 South 57398827 34400661 55795055 62597750 51555882 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10019 West 62042214 26623353 78594431 96522414 10020 West 69868417 Print Amount Product 20.52 18.12 23.98 23.85 15.42 17.30 179.94 21.84 15.92 24.38 25.14 20.39 20.28 153.44 21.01 23.23 DVD DVD DVD Book Book. DVD Book Book DVD DVD Book Book DVD Book DVD DVD 21.83 Book 20.16 Book 17.95 DVD 18.18 DVD. Done O Use Pivot Tables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by region and product in the accompanying Sales Transactions data Click the icon to view the Sales Transactions data. Use Pivot Tables to find the number of sales transactions by product and region. (Type whole numbers.) Count of Amount Book DVD Grand Total East North South West Grand Total ELE Sales Transactions Cust ID Region Transaction Code 10001 East 94108738 10002 West 74083490 10003 North 64942368 72753924 35208817 10004 West 10005 South 10006 West 10007 East 10008 West 20978903 80321173 14132683 10009 West 40128225 10010 South 51285539 10011 South 57398827 34400661 55795055 62597750 51555882 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10019 West 62042214 26623353 78594431 96522414 10020 West 69868417 Print Amount Product 20.52 18.12 23.98 23.85 15.42 17.30 179.94 21.84 15.92 24.38 25.14 20.39 20.28 153.44 21.01 23.23 DVD DVD DVD Book Book. DVD Book Book DVD DVD Book Book DVD Book DVD DVD 21.83 Book 20.16 Book 17.95 DVD 18.18 DVD. Done O

Answer rating: 100% (QA)

Answer The pivot table is made using the above data and the below information is extracted as The nu... View the full answer