Use Pivot Tables to find the number of sales transactions by

Last updated: 6/27/2023

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 Transact 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 Sales Transactions Cust ID 10001 10002 Region East West 10003 North 10004 West 10005 South 10006 West 10007 East 10008 West West South 10011 South 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10009 10010 DVD DVD 24 52 Book 15 61 17 30 179 37 Book DVD Book 22 99 Book Transaction Code Amount Product 93852577 20 43 DVD 74083490 18 07 64942368 23 98 70264827 35208817 20978903 80292759 14132683 40128225 49656996 57398827 34400661 54782609 62597750 51555882 64500628 26623353 78591421 15 92 DVD 24 95 DVD 26 17 Book Book DVD 20 39 20 59 152 49 Book 21 01 23 26 21 81 DVD DVD Book 20 16 Dal 0 X