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 FL G A B C D E 1 Cust ID Region Transactio Amount Product 23 2 10001 East 94410814 20.53 DVD 3 10002 West 74083490 17.94 DVD 45 10003 North 64942368 23.98 DVD 5 10004 West 70819543 25.21 Book 6 10005 South 35208817 15.83 Book 7 10006 West 20978903 17.3 DVD 8 10007 East 80122030 178.12 Book 9 10008 West 14132683 22.68 Book 10 10009 West 40128225 15.92 DVD 11 10010 South 52650126 23.71 DVD 12 10011 South 57398827 25.66 Book 13 10012 East 34400661 20.39 Book 14 10013 North 55168089 22.15 DVD 15 10014 East 62597750 151.93 Book 16 10015 west 51555882 21.01 DVD 17 10016 West 54991028 23.13 DVD 18 10017 West 26623353 21.89 Book 19 10018 West 78594431 20.16 Book 20 10019 West 92784212 18.14 DVD 21 0020 West 69868417 17.89 DVD