City	Customer Name	Customer Segment	Order Date	Order Priority	Region	Ship Mode	Sales	Shipping Cost
McKeesport	Jessica Myrick	Small Business	01/01/12	High	East	Regular Air	45 000	4000
Bowie	Matt Collister	Home Office	01/01/12	Critical	East	Express Air	42000	6000
Napa	Alan Schoenberger	Corporate	02/01/12	Low	West	Delivery Truck	18000	3000
Montebello	Elizabeth Moffitt	Consumer	02/01/12	Critical	West	Regular Air	48000	6000
Napa	Alan Schoenberger	Corporate	02/01/12	Low	West	Delivery Truck	17000	3000
Montebello	Elizabeth Moffitt	Consumer	02/01/12	Critical	West	Express Air	38000	6000
Prior Lake	David Philippe	Consumer	02/01/12	Critical	Central	Regular Air	18000	6000
Napa	Alan Schoenberger	Corporate	02/01/12	Low	West	Regular Air	62000	3000
Phenix City	Patrick Jones	Home Office	03/01/12	High	South	Delivery Truck	31000	4000
Draper	Larry Tron	Home Office	03/01/12	High	West	Regular Air	16000	4000
Phenix City	Patrick Jones	Home Office	03/01/12	High	South	Regular Air	15500	4000
Lake Oswego	Alex Russell	Home Office	03/01/12	High	West	Regular Air	14500	4000
Kearney	Bill Donatelli	Corporate	03/01/12	Critical	Central	Regular Air	63000	6000
Layton	Ann Steele	Corporate	03/01/12	Low	West	Delivery Truck	32000	3000
Baton Rouge	Andy Reiter	Corporate	03/01/12	Low	South	Regular Air	43000	3000
Kearney	Bill Donatelli	Corporate	03/01/12	Critical	Central	Regular Air	21000	6000
Baton Rouge	Andy Reiter	Corporate	03/01/12	Low	South	Regular Air	43000	3000
Baton Rouge	Andy Reiter	Corporate	03/01/12	Low	South	Regular Air	55000	3000
Bryan	Dave Hallsten	Home Office	04/01/12	High	Central	Delivery Truck	32000	4000
Pharr	Tamara Dahlen	Corporate	04/01/12	Critical	Central	Regular Air	17000	6000
Pharr	Tamara Dahlen	Corporate	04/01/12	Critical	Central	Express Air	21000	6000
Bedford	Darren Budd	Consumer	05/01/12	Critical	Central	Regular Air	19000	6000
Bedford	Darren Budd	Consumer	05/01/12	Critical	Central	Regular Air	23000	6000
Dubuque	Marina Lichtenstein	Corporate	05/01/12	High	Central	Delivery Truck	39000	4000
Bedford	Darren Budd	Consumer	05/01/12	Critical	Central	Regular Air	32000	6000
Bedford	Darren Budd	Consumer	05/01/12	Critical	Central	Regular Air	37500	6000
Norman	Pauline Chand	Small Business	05/01/12	Critical	Central	Regular Air	49000	6000
Ormond Beach	Valerie Dominguez	Corporate	05/01/12	High	South	Regular Air	65500	4000
Deer Park	Dorris Love	Home Office	05/01/12	Critical	East	Regular Air	75000	6000
Fort Dodge	Matt Collins	Consumer	05/01/12	High	Central	Regular Air	65500	6000

You have been learning to use pivot tables for summarising and analysing data in one of this module's study units. You found the topic exciting and have come across the attached Walmart stores data. Create pivot charts and graphs to show how Walmart performs in its operating regions. Required: 3.1 Create a pivot table to show the regional shipping costs. (3 marks) 3.2 Create a pivot table to show the total regional sales. (3 marks) 3.3 Create a pivot table to show the total sales per region and customer segment. (3 marks) 3.4 Create a pivot table showing each region's total order priority count. (3 marks) 3.5 Create a pivot chart to show the total regional sales, shipping cost, and order of priority per customer segment (3 marks) 3.6 Create a pivot chart showing the shipping mode count used in each region. (3 marks)