Forum Discussion
Solved
Subtract two table with condition
Hello Community
I am trying to subtract the "No" column (Table 2) from to "No" column (Table 1) and want to display the result by the "Name" column.
I have tried using UNION and SUMMARIZEDCOLUMNS, but it is not showing me the correct result.
Can someone help me?
| Table 1 | |
| Name | No |
| A | 1 |
| A | 2 |
| B | 3 |
| B | 1 |
| C | 2 |
| C | 3 |
| Table 2 | |
| Name | No |
| A | 2 |
| B | 3 |
| C | 4 |
| A | 4 |
| A | 2 |
| A | 2 |
| Expected Result | |
| Name | No |
| A | 7 |
| B | -1 |
| C | -1 |
Expanded table, bridge table or disconnected table are all methods to tackle such a simple question.
1 Reply
Expanded table, bridge table or disconnected table are all methods to tackle such a simple question.