Dear Colleagues,
Thanks for your help! I was trying to multiply two tables but cannot figure it out. I did search the community but cannot find an applicable solution. Say we have table 1 and table 2 as below. And we would like to output table 3.
Table 1:
| Partner | Ownership % |
| A | 40% |
| B | 60% |
Table 2:
| Category | Amount |
| Cash | 10,000 |
| Inventory | 25,000 |
| Debt | -15,000 |
Table 3:
| Partner | Category | Ownership X Amount |
| A | Cash | 4,000 |
| A | Inventory | 10,000 |
| A | Debt | -6,000 |
| B | Cash | 6,000 |
| B | Inventory | 15,000 |
| B | Debt | -9,000 |
