MFGdatahound
New Member
- Joined
- Feb 6, 2015
- Messages
- 7
Hello geniuses,
Imagine the table below is longer with more variables. Each color is a company. Number is dollars earned. There are three different businesses: A, B, and C. I'm trying to take the full sum of each company's book of business, but classify them by the more dominant business. So if Yellow made $8, 3$ of that was through business B, but the more profitable was business A. The result would output "A" because it was the stronger business. I have no idea how to do it, and there are too many companies to filter each field.
<tbody>
</tbody>
<tbody>
</tbody>
Appreciate any advice,
Thanks.
Imagine the table below is longer with more variables. Each color is a company. Number is dollars earned. There are three different businesses: A, B, and C. I'm trying to take the full sum of each company's book of business, but classify them by the more dominant business. So if Yellow made $8, 3$ of that was through business B, but the more profitable was business A. The result would output "A" because it was the stronger business. I have no idea how to do it, and there are too many companies to filter each field.
Company | $ | Business |
<tbody>
</tbody>
Yellow | 5 | A |
Yellow | 3 | B |
Orange | 1 | C |
Blue | 8 | C |
Blue | 1 | B |
Blue | 8 | B |
Green | 2 | A |
Green | 8 | B |
Red | 2 | A |
Red | 3 | A |
Red | 9 | A |
Red | 9 | B |
Red | 5 | C |
<tbody>
</tbody>
Appreciate any advice,
Thanks.