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 Product
10001 East 94361225 20.37 DVD
10002 West 74083490 18.11 DVD
10003 North 64942368 23.98 DVD
10004 West 70385587 23.81 Book
10005 South 35208817 15.82 Book
10006 West 20978903 17.30 DVD
10007 East 80161506 179.89 Book
10008 West 14132683 21.92 Book
10009 West 40128225 15.92 DVD
10010 South 51357358 24.29 DVD
10011 South 57398827 25.79 Book
10012 East 34400661 20.39 Book
10013 North 55124884 20.81 DVD
10014 East 62597750 153.27 Book
10015 west 51555882 21.01 DVD
10016 West 56999364 23.23 DVD
10017 West 26623353 20.98 Book
10018 West 78594431 20.16 Book
10019 West 92881032 17.66 DVD
10020 West 69868417 17.89 DVD