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. am Count of Amount East North South West Grand Total Book 3 0 2 4 9 DVD 1 2 1 11 Grand Total 11 20 Use Pivot Tables to find the total amount of revenue by region. (Type integers or decimals. Do not round.) East North South West Grand Total 372.68 43.79 63.99 220.66 Sum of Amount 701.12 Sales Transactions Cust ID Region 10001 East 10002 West 10003 North 10004 West 10005 South 10006 West 10007 East 10008 West 10009 West 10010 South 10011 South Transaction Code Amount Product 94434609 20.51 DVD 74083490 17.97 DVD 64942368 23.98 DVD 71724961 23.74 Book 35208817 15.88 Book 20978903 17.30 DVD 80164197 179.42 Book 14132683 22.33 Book 40128225 15.92 DVD 50130386 25.14 DVD 57398827 25.07 Book Sales Transactions 10009 West 10010 South 10011 South 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10019 West 10020 West 40128225 50130386 57398827 34400661 56285119 62597750 51555882 65037973 26623353 78594431 92316552 69868417 15.92 DVD 25.14 DVD 25.07 Book 20.39 Book 19.88 DVD 153.48 Book 21.01 DVD 23.18 DVD 21.51 Book 20.16 Book 17.58 DVD 17.86 DVD 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. am Count of Amount East North South West Grand Total Book 3 0 2 4 9 DVD 1 2 1 11 Grand Total 11 20 Use Pivot Tables to find the total amount of revenue by region. (Type integers or decimals. Do not round.) East North South West Grand Total 372.68 43.79 63.99 220.66 Sum of Amount 701.12 Sales Transactions Cust ID Region 10001 East 10002 West 10003 North 10004 West 10005 South 10006 West 10007 East 10008 West 10009 West 10010 South 10011 South Transaction Code Amount Product 94434609 20.51 DVD 74083490 17.97 DVD 64942368 23.98 DVD 71724961 23.74 Book 35208817 15.88 Book 20978903 17.30 DVD 80164197 179.42 Book 14132683 22.33 Book 40128225 15.92 DVD 50130386 25.14 DVD 57398827 25.07 Book Sales Transactions 10009 West 10010 South 10011 South 10012 East 10013 North 10014 East 10015 West 10016 West 10017 West 10018 West 10019 West 10020 West 40128225 50130386 57398827 34400661 56285119 62597750 51555882 65037973 26623353 78594431 92316552 69868417 15.92 DVD 25.14 DVD 25.07 Book 20.39 Book 19.88 DVD 153.48 Book 21.01 DVD 23.18 DVD 21.51 Book 20.16 Book 17.58 DVD 17.86 DVD