Create a pivot table that shows sales revenue by region for each of the four years and quarters ( excel)

Create a pivot table that shows sales revenue, total cost, and gross profit for each year.

region	date_of_sale	item	brand	collection	description	list_price	cost	quantity_sold	Sales Revenue	total cost	gross profit
Central	1/2/2018	Z115-96BNBDL	Riders	Lindos	96" CC pull	$ 4.87	$ 3.16	446	$ 2,172.02	$ 1,409.36	$ 762.66
Central	1/2/2018	33854ALM*	Jeffrey Alexander	Slade	Knob	$ 11.81	$ 1.09	569	$ 6,719.89	$ 620.21	$ 6,099.68
West	1/2/2018	293-224PC	Elements	Zane	224 mm CC pull	$ 22.65	$ 14.38	558	$ 12,638.70	$ 8,024.04	$ 4,614.66
Northeast	1/2/2018	107DBAC	Jeffrey Alexander	Capri	Knob	$ 15.05	$ 3.24	726	$ 10,926.30	$ 2,352.24	$ 8,574.06
Midwest	1/2/2018	CL101-NI	Elements	Latches	Cabinet Latch	$ 12.65	$ 7.41	606	$ 7,665.90	$ 4,490.46	$ 3,175.44
Northwest	1/3/2018	211SN	Jeffrey Alexander	Naples	Knob	$ 11.95	$ 7.14	721	$ 8,615.95	$ 5,147.94	$ 3,468.01

Answer rating: 100% (QA)

Table 1 Sum of Sales Revenue Year Qtrs region Total 2018 Qtr 1 C... View the full answer