Can someone please help me get the Excel Formula to get the Total Sales? Thanks.

tInvoice Header = Invoice Fact Table = Invoice Level/ Grain Dimention Table for fLineltemInvoice Detail One Side for flineltemInvoice Detail Fact Table Date Shipping Costs Invoice Weight 6 3 5 Invoice Number 5/12/19 5/12/19 5/12/ 19 5 5/13/19 5/13/19 5/13/19 5/13/ 19 5 5/14/19 5/14/19 5/14/19 6 SalesReplD 5814 5815 816 5817 5818 5819 820 5821 5822 5823 Invoice Sales 249 5 186 856 340 562 61 591 Invoice Discount 487 336.5 911 411 769.5 95.5 598.5 119 59.5 238 5 181.66 3773.94 12955.46 5694.35 9364.87 1141.31 10542.76 7106.52 2901.6 10564.78 % Sales Discount 0.048054098 0.049285362 0.066072528 0.059708307 0.060011511 0.053447354 0.056057427 0.073312958 0.053418803 0.056981783 1129 558 4211 1895 2048.5 305 830 2251 1007.5 2379 2 2 5 2 6 521 155 602 5 LineltemlhvoiceDetail = Line Item Invoice Detail Fact lbl = Line Item Level Grain Fact Table for finvoice Header Fact Table for dProduct nvoice Number Quanity Line Discount Line Weight 435 ProductID 5814 5814 5814 5814 5815 5816 5816 5816 5816 5817 58173 5818 5818 5818 5819 5820 5820 5820 5821 5821 5822 5823 5823 5823 3 5823 WNPAwNNA WNW NA WNWAAWN Unit Price 87 59 51 52 186 277 246 276 57 105 235 270 65 227 61 119 285 187 285 236 155 112 243 65 182 17.47 20.21 22.46 25.46 20.29 13.16 14.22 15.8 25.46 18.87 15.8 14.22 22.46 17.91 18.71 18.87 15.8 20.29 13.16 14.22 18.72 17.47 14.22 22.46 20.29 Line Shipping 73.03694376 187.639504 57.2992265 89.074845 55.04404766 142.9942427 63.61978208 67.29140833 186 336.5 240.8555096 299.6283543 231.1296334 186.2671574 288.1290823 388.1106626 95.8857748 36.99382569 118.3030548 79.70580475 221.6969452 331.2941953 230.4081957 354.9804735 87.61080506 158.7082011 243.9809992 255.8113254 61 295.5 125.8786342 88.08312721 252.4265942 391.7742933 212.6947716 118.6425795 274.9675791 75.33318525 246.0324209 43.66681475 155 59.5 111.4928356 56.0235393 196.8982714 85.08575032 83.18770481 42.26775956 210.4211881 54.62295082 206.5 331.5 156 558 1385 861 1794 171 367.5 1527.5 945 422.5 681 305 416.5 1852.5 561 1425 826 1007.5 560 850.5 422.5 546 1 dProduct = Dimension/Lookup Table Dimention Table for fLineltemInvoice Detail One Side dSales Rep = Dimension/Lookup Table Dimention Table for finvoice Header One Side ProductID Weight oz. SalesReplD 5 Name 1 Bellen 2 Carlota 3 Sunbell 4 Quad Category Beginner Freestyle Beginner Freestyle 3.5 6.5 Sales Rep 1 Sioux Radcoolinator 2 Abdi Cruz 3 Chantel Davis 4 Tyrone Thomas 5 Gigi Smithe | 6 Tan Pham Region North Noth East East West West Toatl Sales Product Bellen Carlota Quad Sunbell Total Shipping Total Discounts 12013.76 761.352868 914.1245828 19568.17 1205.949437 926.863973 18101.66 1012.602516 869.8620897 19543.66 1143.095179 1514.649354 Totals 69227.25 4123 4225.5 ANSWER TO PROBLEM: Total Sales Product Bellen Carlota Sunbell Quad Total Shipping 914.1245828 926.863973 1514.649354 869.8620897 Total Discount 761.352868 1205.949437 1143.095179 1012.602516 Total 4225.5 4123