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. Use PivotTables to find the number of sales transactions by product and region. Cust ID Region Transaction Code Amount Product10001 East 94361225 20.37 DVD10002 West 74083490 18.11 DVD10003 North 64942368 23.98 DVD10004 West 70385587 23.81 Book10005 South 35208817 15.82 Book10006 West 20978903 17.30 DVD10007 East 80161506 179.89 Book10008 West 14132683 21.92 Book10009 West 40128225 15.92 DVD10010 South 51357358 24.29 DVD10011 South 57398827 25.79 Book10012 East 34400661 20.39 Book10013 North 55124884 20.81 DVD10014 East 62597750 153.27 Book10015 west 51555882 21.01 DVD10016 West 56999364 23.23 DVD10017 West 26623353 20.98 Book10018 West 78594431 20.16 Book10019 West 92881032 17.66 DVD10020 West 69868417 17.89 DVD