If I have a dataset that looks something like this
| #of passengers | Route | number of flights | cost per fl | revenue from each fl | profit from each fl |
|---|---|---|---|---|---|
| 194 | RSW-CLE | 14 | 19409.50 | 74302 | 54892.50 |
| 110 | RSW-CMH | 12 | 19409.50 | 53350 | 33940 |
| 182 | ATL-LAX | 11 | 18537.40 | 44226 | 25688.60 |
| 134 | ORD-LAX | 8 | 12574.45 | 78413 | 151446.60 |
First I want to add the total cost per fl, total profit per fl and then I want to show the routes with the most profit in a summary file. How do I go about doing that?