HELP WILL LIKE!! idk how to do the drill down step!!! and last step!!

Refresh the PivotTable so that the new transaction is included in the Analysis and then clear all Pivot Table filters Create a drill-down of the December, 2022 Apple Pay transactions onto a new worksheet and name the worksheet ApplePay Transactions lio ler be he 9 PivotCharts can add a visual component to your analysis with options to filter specific records Create a PivotChart based on the data in the SalesData table Start the analysis on a new worksheet, renamed to be RevenueByPaymentType The PivotChart should be a Pie Chart that shows the proportion of Net Revenue from each Payment Type Use Years as the filter so that you can see the data for any given year Move the Pie Chart to its own worksheet named RevenueBy TypePivotChart Edit the chart title to be Proportion of Revenue by Payment Type Use the Years Filter to only show transactions from 2022 10 Save and close Excel_Ch06_Prepare_SalesAnalysis xlsx Exit Excel Submit the file as directed A9 X & fx Dec LL F G Employee EMP-00024 EMP-00026 A B DE 1 Club Member? Yes . 2 3 Total Net Revenue Payment Type 4 Quarters By Year Apple Pay Card Cash Grand Total 5 3 2022 84.08% 7.33% 2.30% 93.71% 6 BQtr 4 84.08% 7.33% 2.30% 93.71% 7 Oct 34.46% 0.00% 2.30% 36.76% 8 Nov 0.00% 0.10% 0.00% 0.10% 9 Dec 49.62% 7.23% 0.00% 56.85% 10 2023 0.00% 0.00% 6.29% 6.29% 11 Qtr 1 0.00% 0.00% 6.29% 6.29% 12 Jan 0.00% 0.00% 6.29% 6.29% 13 Grand Total 84.08% 7.33% 8.60% 100.00% 14 EMP-00038 EMP-00076 EMP-00015 K . D E F G H 1 Pro Shop Sales Database 2 3 Trans TransDate EMP-ID Itemid Payment Type - Quantity GrossRevenue Club Member 4 P000100 10/3/2022 EMP-00076 C884P23 Cash 3 S 17100 No 5 PO00101 10/3/2022 EMP-00038 T822248 Cash 2 S 65 90 No 6 PO00102 10/3/2022 EMP-00024 F232P37 Apple Pay 1 $ 129.00 Yes 7 POO0103 10/5/2022 EMP 00015 C583%29 Apple Pay 3 $ 177.00 No 8 PO00104 10/6/2022 EMP-00026 F232P37 Credit 3 5 38700 No 9 PO00105 10/12/2022 EMP-00076 F375P67 Cash 3.5 46 35 Yes 10 PO00106 10/16/2022 EMP-00038 X740029 Apple Pay 1 453 00 Yes 11 PO00107 10/22/2022 EMP-00024 T981911 Credit 15 1200 No 12 PO00108 10/25/2022 EMP-00015 C884P23 Cash 2 s 11400 No 13 P000109 11/2/2022 EMP-00026 X487P48 Credit 3 $ 1,257 00 No 14 PO00110 11/7/2022 EMP-00076 R483P24 Apple Pay 1$ 200 No 15 PO00111 11/10/2022 EMP-00038 R483P24 Card 15 200 Yes 16 PO00112 11/19/2022 EMP 00024 X349R39 Credit 3 $ 149.85 No 17 PO00113 11/23/2022 EMP-00015 F833K19 Apple Pay 3 $ 17 85 No 18 PO00114 12/13/2022 EMP 00026 R239157 Card 29 19400 No 19 POO0115 12/14/2022 EMP-00076 CSB3K29 Card 1 s 59.00 No 20 PO00116 12/16/2022 EMP-00038 F375P67 3 $ 46.35 No 21 PO00117 12/18/2022 EMP-00024 X487P48 Apple Pay 2.5 838 00 Yes 22 PO00118 12/24/2022 EMP-00015 F833K19 Apple Pay 4 S 2380 No 23 POO0119 12/29/2022 EMP-00026 F232P37 Card 1 $ 129.00 Yes 24 P000120 12/31/2022 EMP-00076 X487P48 Apple Pay 2 $ 838.00 No 25 PO00121 1/1/2023 EMP-00024 T822248 Cash 35 98.85 Yes 26 27 28 Coupon Cash Disc NetRevenue TotalDiscounts 15% 5% S 136.80 $ 34 20 $ 65 905 5 119.97 $ 9.03 $ 177.00 S 15% 5% 5 309.60 $ 77.40 15% $ 36.15 S 10 20 S 421 29 $ 31 71 $ 1200 $ 5% S 108 30 $ 5.70 10% $ 1,131 30 $ 125.70 10% $ 1.80 $ 0.20 15% $ 156 $ 0.44 5% $ 142 36 $ 749 5% 5 16.96 S 089 15% s 164 90 $ 29 10 $ 59 00 $ 46 35 5 S 779.34 $ 58 66 $ 23 80 5 SX $ 113 525 15 48 $ 83800 $ 98 85$ Cash