Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use PivotTables to find the number of sales transactions by product and region, total amount of revenue by region, and total amount of revenue by
Use PivotTables 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 PivotTables 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 3 0 2 4 9 1 2 1 7 11 4 2 3 11 20 Use PivotTables to find the total amount of revenue by region. (Type integers or decimals. Do not round) Sum of Amount East North South West Grand Total Use PivotTables to find the revenue by region and product (Type integers or decimals Do not round) Sum of Amount East North South West Grand Total Book DVD Grand Total A B C D E F G 1 Cust ID Region Transaction Code Amount Product 2 10001 East 94098506 20.33 DVD 3 10002 West 74083490 18.09 DVD 4 10003 North 64942368 23.98 DVD 5 10004 West 72760917 24.66 Book 6 10005 South 35208817 15.97 Book 7 10006 West 20978903 17.3 DVD 8 10007 East 80208957 179.14 Book 9 10008 West 14132683 22.23 Book 10 10009 West 40128225 15.92 DVD 11 10010 South 53143294 24.04 DVD 12 10011 South 57398827 24.87 Book 13 10012 East 34400661 20.39 Book 14 10013 North 54907447 21.44 DVD 15 10014 East 62597750 153.35 Book 16 10015 west 51555882 21.01 DVD 17 10016 West 64959102 23.06 DVD 18 10017 West 26623353 19.95 Book 19 10018 West 78594431 20.16 Book 20 10019 West 94816597 18.02 DVD 21 10020 West 69868417 18.17 DVD 22 23 24 25
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started