Please solve this. At least show me on some example how to solve

10 Bonus: calculate the Shipping cost for single item using a calculated field within pivot GOOD LUCK :) NOTE: please use excel functions and formulas instead of manipulating data manually. 03:47 Done 6 Tasks Employee Data Age INDEX FULL NAMPREFIX FIRSTNAMRUDOLEN/LANTNAMBAFFIX AGE Abbu DVM Liedtke 1 M Amic 2 Mk Aurelie Toma 3 Se Ferreira Fibe 4 Ma Darby 5 Dr Jayden Mr Marias Ms Amiya Pince Mr. Ma Amelia Mr Toby Eth Si Mrs Ashley Ma Megan Hr Helmut Prod. Milena Hr. Lothar Hr Pict Hr Richard Dr Earnestine Mr. Mr. Jason Kendrick Amabell Dr Dr Jena Dr Shmay Dr Tia Ma Isabel Hr Barney Hr Banach Prod Liesbeth Mew Valartine Mme Palette Mme M M M. M. M M S Se Sea Sea Sea Sa Mw a Mw Fre H. Se 7 8 9 10 11 12 13 14 15 16 17 18: 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 MASHUG#****** 38 39 40 41 42 43 ++ 45 46 47 48 49 50 Test Excel_WIP.xlsx all ? Revenue Data Laure-Alix Claude Vic Arthur Benjamin Arne Bemand Hidalgo Hadalge Lam Ainhoa Isabel Carlota Eliae Ryan Eline Majam Berod Adriano Postes Cantu ZODIAC EM Libe Aquaria Cancer Tane Sagitarios Lee Tama Aquarian Sagitarias Scorpi Libes Aquarias Virge Pan Cancer Libu Virge Taurin Caprico Cancer Aries Sagitarias Virge Cancer Anies Cancer PINES Aquarias Liba Caprico Scorpio Liba Lav Aquaries Cancer Cpri Sagitarian Ge Aquarias Pion Loo Tamm Libes Aries Tamn Pixes Lee Done Data Age EIGHTE VAGAS 3.2 E 111 Iev 144 40 ME THE NI NU INT 4U IMR L THE INI HI *** po 191 INL 164 20 lat ENE H HE ARE 194 116 2 AME THE THE 140 14 IN HE JA 176 IN THE 03:47 14 THE NI 200 Revenue Data D BL + 8130- 18. AA A D 0- INF A VIC LA THE IM NOOR METH HUG 1 FLEMM 147 B M AND MED T THE 43 G ALL MA YA M L MF May BLA INF 176 1) A 107 SLA IM ALP M Ande menc W MEK METH 51.5 T MODE CH E Test Excel_WIP.xlsx HOMES Meshk Karty Bad INDEKIR no d lenk taps Fende fagplast 14 Nga (54 BOOK poor hung ary Ma Tal Ways To Find Tighed 154 Way the fight 18 Sele (Tery of Made Ingla S M Ingl 18 UN Caty Caly teed Oak From th Fond I (K OUTDOO T Mas Come We Fondame Very Wary Mary Ma DOOR ladal sh OUTDOOM POKR Tak A Mod M Mary Carly 8000 M Mary Stank Rick Way Abre Seapleid TOOR Bak Choog Wind W Mary ACORD eagle CBOOK helytalas 0 Way 4 Sumb Way hah Alady 4 City A www B omulg Very 000 CTM Wary Bak (UTICO Caty V Wary BOD 415 -V -0 BLA 3 TEAM T 0- A A A 0 . A P A A 4 -0 0 . A 0 O 6 0 0 + A N An Kood p 2000 P offres eight Wick Wavy POME www PEK XOLO d CRUTDOORO OUTDOOR Ou what when the Ja panty w 10000 P PRODROM MERCOLEDO Rg Gala **** BORION all ? tight T Figh Ing Mome of no Fred Frod M Maha RA Ma Mond Funch Video Mal Spok Frode Spok was on m 993 KINE 1 03:47 Done Tasks Test Excel_WIP.xlsx Age Employee Data 43 55 36 21 55 30 26 55 29 32 25 Name Ryan Plan De Annabell O Dr. Eamestine Raynor Dr. Jaydon Bo De Jana Up De Sy Dr. Tin Absline Fra. Mirjam Soder IL Bern Pal Hr. Bamey Wesak Hr. Barch Kade He Helst Wenha Hr. Lothar Bambam He Pro Ste He Richard Thauck M. Antoine Maillard St Arthur L M. Benjamin Lebrun-Brun M. Bad Hoyon M. Claude Ton M. Victor Len Mine Laure-Alis Chea Mme Palene Durand Mme Valentine Mere Mr. Jon Gaylord Mr. Kendrick St M. Meriah Lynch Mr. Pierce M. Toby Simpien Mrs Ashley Wind Ms Amelia Stevens Ms. Amiya Fachmas Ms. Anne Abb M. Au Lachke Ms. Darby Cruickshank Ms. lubel Runother M. Megan Sce Mw Elise Roteved Me liee Prin Prof Liesbeth Re Prof. Milena Scho Sir Dhin Murphy St. Adriano Subriche St. Hadalgo Place St. Hidalgo Tercero Sr. Tomis Filho Sea, Ainhoa Garm Sra. Caroleta Manic Sa label Hand St. Laura Olivier 31 41 34 58 35 33 22 34 46 22 31 42 57 55 32 38 34 39 34 54 44 35 36 30 24 41 37 36 23 4K 24 37 60 35 33 49 all ? Revenue Data 03:47 Done Excel_WIP.xlsx Test Tasks Employee Data Age Revenue Data Order Date 21/12/15 Region Item Units Unit Cost Central Binder 28 Total Shipping Total 139,72 632.63 4,99 15/1/15 Central Binder 46 8,99 413,54 262,85 31/5/15 Central Binder 80 8.99 719.2 361,39 12/7/14 1,99 57,71 736,53 East Binder 17/11/15 Central Binder 4,99 54,89 772.32 4/12/15 Central Binder 19,99 1,879,06 943.38 18/2/15 East Binder 4,99 19.96 792.8 East Binder 60 4,99 299,4 369,84 1/4/14 8/6/14 East Binder 60 8.99 539,4 755,93 19,99 999,5 189,17 23/1/14 Central Binder 50 5/10/14 Central Binder 8,99 251,72 574.39 East Binder 19,99 1.619,19 600,41 29/7/14 1/2/15 Central Binder 1.305,00 186,85 15 19.99 139.93 149,03 7/3/15 West Binder 14/10/15 West Binder 17/6/15 Central Desk 19,99 1.139,43 547,62 125 625 792,83 1/9/14 Central Desk 125 250 168,33 Desk 275 825 208,43 24/8/15 West 26/2/14 Central Pen 19,99 539,73 886,09 27/4/15 East Pen 4,99 479,04 929.63 22/10/14 East Pen 8.99 575,36 212,62 8/11/14 East Pen 19,99 299,85 998,27 27/9/15 West Pen 1,99 151,24 421.99 24/3/15 Central Pen Set 50 4,99 249,5 153.28 18/9/14 East Pen Set 800.04 15,99 255,84 309,38 4/7/15 East Pen Set 62 4,99 303.2 503.13 Central Pen Set 42 23.95 1,005,90 Set Set 889,4 7/8/15 25/11/14 Central Pen 21/7/15 Central Pen 29/12/14 East Pen 31/10/15 Central 10/4/15 Central 18/4/14 Central Penol 4,99 479,04 12,49 680,95 15.99 1.183.26 988.46 463,67 Set Pencil Pencil 1.29 18,06 817,95 131.34 117.82 1,99 1,99 149.25 267,51 1,29 9,03 312.07 10/9/15 Central Pencil 14/5/15 Central Pencil 1,29 69.37 290,65 9/2/14 Central Pencil 331.39 5/5/14 Central Pencil 90 4,99 179,64 4,99 449,1 4,99 174.65 756.2 15/8/14 East 548.52 Pencil East Pencil Pencil 1,99 189,05 6/1/14 25/6/14 Central 12/12/14 Central Pencil 322.41 4,99 449,1 605.4 753.97 1.29 86.43 2,99 167,44 15/3/14 West Pencil 806,1 22/5/14 West Pencil 1,99 63.68 450.34 N 389858%87853=8289-22888+1=38% 94 96 64 76 16 74 66 36 90 all ? 67 56