+----+-----+-------+---------+
| ID | Qty | Value | AgnstID |
+----+-----+-------+---------+
| A1 | 100 |   100 | -       |
| B1 | 100 |   100 | A1      |
| A2 | 100 |   100 | -       |
| B2 |  50 |    50 | A2      |
+----+-----+-------+---------+

+----+------+------+------+------+-------+
| ID | Qty1 | Qty2 | Val1 | Val2 | Val12 |
+----+------+------+------+------+-------+
| A1 |  100 |    0 |  100 |    0 |   100 |
| B1 |    0 |  100 |    0 |  100 |   100 |
| A2 |  100 |    0 |  100 |    0 |   100 |
| B2 |   50 |    0 |   50 |    0 |    50 |
+----+------+------+------+------+-------+