I have a table as below.
Airport name U.S.D ALY 111,447.70 ALY 559,557.23 LXR 12,827.16 LXR 79,720.62 HRG 1,353.77 HRG 1,187,334.08 SSH 8,417.65 SSH 2,900,602.08 TCP 6,363.41 TCP 90,279.68 TCP 18,567.52
In another table I would like the sum of the amounts from the first table by specific airport:
airport name total Amount of each airport ALY 671,004.93 LXR 292,547.78 HRG 1,188,687.85 SSH 2,909,019.73 TCP 115,210.61
How do I make the second column in the second table calculate the SUM automatically from the first table?