Use pivot tables to find the number of sales transactions by product and region, the total amount of revenue by region, and the total amount of revenue by region and product in the accompanying sales transaction data.

Client ID	Region	Transaction code	Amount	Product
10001	It is	94229674	20.46	DVD
10002	West	74083490	18.09	DVD
10003	Norte	64942368	23.98	DVD
10004	West	71769545	24.75	Book
10005	On	35208817	15.42	Book
10006	West	20978903	17.30	DVD
10007	It is	80167293	178.37	Book
10008	West	14132683	22.56	Book
10009	West	40128225	15.92	DVD
10010	On	52719590	23.89	DVD
10011	On	57398827	24.46	Book
10012	It is	34400661	20.39	Book
10013	Norte	56005132	22.06	DVD
10014	It is	62597750	153.38	Book
10015	West	51555882	21.01	DVD
10016	West	56472871	22.99	DVD
10017	West	26623353	20.91	Book
10018	West	78594431	20.16	Book
10019	West	92919041	18.11	DVD
10020	West	69868417	17.76	DVD

Quantity count
	It is	Norte	On	West	Grand total
Book	anything	anything	anything	anything	anything
DVD	anything	anything	anything	anything	anything
Grand total	anything	anything	anything	anything	anything