Hi there,
We have this table
| id | A | B | C | D |
| 111 | 1 | 0 | 0 | 1 |
| 222 | 1 | 1 | 0 | 1 |
| 333 | 1 | 1 | 1 | 0 |
| 444 | 0 | 1 | 0 | 1 |
We're trying to count the overlapped columns to get this output:
For example: the A to B = 2 *.
IDs 222 and 333 have both A and B products, hence it's 2.
And no one has C and D, hence zero, *.
| | A | B | C | D |
| A | --- | 2 * | 1 | 2 |
| B | --- | --- | 1 | 2 |
| C | --- | --- | --- | 0* |
| D | --- | --- | --- | --- |
Thanks for your help!
