Please help!

I am working for so long but I couldn't figure it out.

This is the table

This is the output when I run it. but is wrong

The output spouse to be like this

14. Go to the August Advertising worksheet, which lists all the articles published in August. Jack wants to display the data by article type and then list the projects by publication date. Sort the data in the table in ascending order first by article type and then by publication date. 15. Jack also wants to calculate ad amount subtotals for each article type: a. Convert the table to a range. b. Insert a subtotal at each change in the Article Type value. C. Use the Sum function to calculate the subtotals. d. e. Add subtotals to the Ad Amt values only. Include a summary below the data. Collapse the outline to display only the subtotals for each article type and the grand total. f. A1 X fic Article Title B D E F G Author Article Type Sports Level Ad Amt Article Title 1 2 Last-minute duel in golf 3 European road bicycle racing? 4 This year could be big in tennis 5 Third base is a power position 6 Ranking NBA journeymen 7 Ups and downs in the NFC East 8 Fantasy baseball movers and shakers 9 Ups and downs in the NFC South 10 Women's softball championship 11 Ups and downs in the NFC North 12 Had enough with preseason football? 13 Ankle injuries are killing the NBA's best 14 NFL waiver wire 15 Major league baseball is for the young 16 College football is around the corner 17 Quarterback stability is everything 18 Women's soccer and more 19 Eleventh-inning errors 20 Hernandez comes roaring back 21 Pace of MLB rebuild picks up 22 Time for another MLB expansion? 23 Head-to-head points and ranks 24 New to fantasy baseball? 25 Closer trends and strategies 26 Hidden college football stars 27 Martin Pedraza Tovar O'Brien Romano Fuentes O'Brien Fuentes Pedraza Fuentes Walsh Romano Fuentes O'Brien Aken Walsh Tovar O'Brien Martin O'Brien Tovar Aken Tovar O'Brien Walsh Publication Date 8/2/2021 8/5/2021 8/7/2021 8/8/2021 8/10/2021 8/10/2021 8/11/2021 8/12/2021 8/12/2021 8/13/2021 8/14/2021 8/15/2021 8/16/2021 8/17/2021 8/18/2021 8/19/2021 8/20/2021 8/21/2021 8/22/2021 8/24/2021 8/25/2021 8/27/2021 8/28/2021 8/30/2021 8/31/2021 Number of Words 322 174 250 314 446 504 482 512 181 524 487 359 397 562 602 434 227 382 280 420 388 230 256 314 477 News Opinion Profile Opinion Analysis Feature Opinion Feature News Feature Opinion Opinion News Profile Feature Opinion News News Analysis Feature Opinion News Feature Analysis Profile Professional Professional Professional College Professional Professional Professional Professional Amateur Professional Professional Professional Professional Professional College College Amateur College High School Professional Professional High School Professional College College $ $ $ S S $ $ S S $ $ S S $ $ $ $ $ S S $ 805 435 625 785 1,115 1,260 1,205 1,280 453 1,310 1,218 898 993 1,405 1,505 1,085 568 955 700 1,050 970 575 640 785 1,193 nunu E57 2 3 A B D E F G H Article Title Author Publication Date Number of Words Article Type Sports Level Ad Amt + + 1 3 5 7 9 + + + + + + + + News Total Opinion Total Profile Total Opinion Total Analysis Total Feature Total Opinion Total Feature Total News Total Feature Total Opinion Total News Total Profile Total Feature Total Opinion Total News Total Analysis Total Feature Total Opinion Total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 11 13 15 17 19 21 24 26 28 30 32 35 37 39 41 805 435 625 785 1,115 1,260 1,205 1,280 453 1,310 2,115 993 1,405 1,505 1,085 1,523 700 1,050 970 + + + + + + + + 12 3 A B E F G H Publication Date D Number of Words Article Title Author Sports Level Ad Amt + + Article Type Analysis Total Feature Total News Total Opinion Total Profile Total Grand Total + 1 5 12 19 27 31 32 33 34 $ 2,600 $ 7,045 $ 4,348 $ 6,595 $ 3,223 $ 23,810 + +