need help using pivot table can some help.me with the assignment please

G Matti staarte.com Her completing the problems, submit this using the process used for other assignments. Be sure to check that you have correctly named your file watch on Create a new worksheet for each new Pivot Table or Chart in this workbook and label te Solution X, where is the problem number (0.9 Solution , Solution 2. Alter Create a Prvot Table with the data showing awerage arcus purchase by marta stahis is the ons nodwether credit card was used in the come purchase our stod ba formate Customer Purchase Birthdate 1012359 12/286 Age 61 73 32 8 Gender Mile Male Annun Purch $3,750 SO 2 3 4 5 No de $1473 9 12 12 13 Male Female Male Malo For Mae Female 45 f11 31 28 40 41 71 44 7 B 9 10 11 12 12 14 Married No No NO Yes Yes Yes NO Yes NO Yes NO No 7129162 97307333 312175 11/2501 11/4139 92482 7/10 1110279 1749 12.2017 7/2918 4128 812554 1122 102002 2 2 . 1 3 D 2 2 5 Credcard Income Home Educ Level No $ 73000 Tert Masters YAS $51.400 Herl High School Yes 52200 Rent Yes $2209 Rard Aastor B Ne $44.000 Own Som college No 320 100 Rent Assoc Rach Yes UNAN Fient Masters Degree Yes $87.900 Rent Assoc a Bach NO SLA100 Own Mesters Degree NO $132.100 Her Aooc on Bach No $ 54,400 Her So bege Na S56700 tiert Ascorbach SO 400 Ren Aycach Yes $ 30,400 Ren chool No nem 5.42,400 Dwn Sume No Rent School Yes 1990 Dwn michache un Yes $ 21.00 Rent mer tohool Yes $ 35.000 Own chcel NO 352500 Own M Yes Own No 52.00 Dwi School Yes $448.00 Rool Some Reninn State City Fas Pen Predia ws Washington Seabe Pensyarin Pesburgh West Washington Seattle EASI New York Buffalo EN ORD South es Houston South Fionda Mam North nois CRC Werl KA Kansas Cit North Boy Chicago Fas Ohio Cand West San Francisco Scuh Memphis North Chicago Set South Texas Houston Fast Parvana Fiadenia w Calonia San Francisco Wed Us Setlake Sou Kentucky Lous South Louisiana New Orleans West Phoenie Nod Indiana Indianapos 1 10 -19 52:21 5560 $1,100 $1.001 30 5613 5014 53915 $2267 51005 53221 511 $15 San 51.00 $250 .53199 $4OTY 52514 50 Te 02 3 2 $45 100 Fee Male Femal Female Male Female Male Male $27.00 M 18 17 18 19 20 21 22 23 24 48 30 41 12 67 2 28 No Yes NO YRS NO Nu Nu NO No Yes Female 1/714 11:24:53 97802 -1215701 Weers Antara 26 Probleme O TOPM TVM F To start G Matti staarte.com Her completing the problems, submit this using the process used for other assignments. Be sure to check that you have correctly named your file watch on Create a new worksheet for each new Pivot Table or Chart in this workbook and label te Solution X, where is the problem number (0.9 Solution , Solution 2. Alter Create a Prvot Table with the data showing awerage arcus purchase by marta stahis is the ons nodwether credit card was used in the come purchase our stod ba formate Customer Purchase Birthdate 1012359 12/286 Age 61 73 32 8 Gender Mile Male Annun Purch $3,750 SO 2 3 4 5 No de $1473 9 12 12 13 Male Female Male Malo For Mae Female 45 f11 31 28 40 41 71 44 7 B 9 10 11 12 12 14 Married No No NO Yes Yes Yes NO Yes NO Yes NO No 7129162 97307333 312175 11/2501 11/4139 92482 7/10 1110279 1749 12.2017 7/2918 4128 812554 1122 102002 2 2 . 1 3 D 2 2 5 Credcard Income Home Educ Level No $ 73000 Tert Masters YAS $51.400 Herl High School Yes 52200 Rent Yes $2209 Rard Aastor B Ne $44.000 Own Som college No 320 100 Rent Assoc Rach Yes UNAN Fient Masters Degree Yes $87.900 Rent Assoc a Bach NO SLA100 Own Mesters Degree NO $132.100 Her Aooc on Bach No $ 54,400 Her So bege Na S56700 tiert Ascorbach SO 400 Ren Aycach Yes $ 30,400 Ren chool No nem 5.42,400 Dwn Sume No Rent School Yes 1990 Dwn michache un Yes $ 21.00 Rent mer tohool Yes $ 35.000 Own chcel NO 352500 Own M Yes Own No 52.00 Dwi School Yes $448.00 Rool Some Reninn State City Fas Pen Predia ws Washington Seabe Pensyarin Pesburgh West Washington Seattle EASI New York Buffalo EN ORD South es Houston South Fionda Mam North nois CRC Werl KA Kansas Cit North Boy Chicago Fas Ohio Cand West San Francisco Scuh Memphis North Chicago Set South Texas Houston Fast Parvana Fiadenia w Calonia San Francisco Wed Us Setlake Sou Kentucky Lous South Louisiana New Orleans West Phoenie Nod Indiana Indianapos 1 10 -19 52:21 5560 $1,100 $1.001 30 5613 5014 53915 $2267 51005 53221 511 $15 San 51.00 $250 .53199 $4OTY 52514 50 Te 02 3 2 $45 100 Fee Male Femal Female Male Female Male Male $27.00 M 18 17 18 19 20 21 22 23 24 48 30 41 12 67 2 28 No Yes NO YRS NO Nu Nu NO No Yes Female 1/714 11:24:53 97802 -1215701 Weers Antara 26 Probleme O TOPM TVM F To start