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

Use PivotTables to find the total amount of revenue by region.

$($Type integers or decimals. Do not round.$)$

Cust ID Region Transaction Code Amount Product

$10001$ East $9386611220\mathrm{.}22$ DVD

$10002$ West $7408349018\mathrm{.}01$ DVD

$10003$ North $6494236823\mathrm{.}98$ DVD

$10004$ West $7269362925\mathrm{.}07$ Book

$10005$ South $3520881715\mathrm{.}71$ Book

$10006$ West $2097890317\mathrm{.}30$ DVD

$10007$ East $80253582178\mathrm{.}58$ Book

$10008$ West $1413268323\mathrm{.}21$ Book

$10009$ West $4012822515\mathrm{.}92$ DVD

$10010$ South $5069531125\mathrm{.}11$ DVD

$10011$ South $5739882726\mathrm{.}05$ Book

$10012$ East $3440066120\mathrm{.}39$ Book

$10013$ North $5575767521\mathrm{.}09$ DVD

$10014$ East $62597750152\mathrm{.}64$ Book

$10015$ west $5155588221\mathrm{.}01$ DVD

$10016$ West $6132733623\mathrm{.}35$ DVD

$10017$ West $2662335322\mathrm{.}29$ Book

$10018$ West $7859443120\mathrm{.}16$ Book

$10019$ West $9104168518\mathrm{.}02$ DVD

$10020$ West $6986841717\mathrm{.}75$ DVD