hello,
I'm working on a straight table and I really can't find a solution for my issue.
My data source looks like this:
Shop_A
Shop_Z
Quantity_shipped
eg
| Shop_A | Shop_B | Quantity_shipped |
| Milan | Rome | 10 |
| Milan | Paris | 50 |
| Milan | Prague | 8 |
| Milan | Bratislava | 20 |
| Rome | Milan | 5 |
| Paris | Milan | 15 |
| Prague | Milan | 10 |
| Bratislava | Milan | 18 |
What I would like to achieve is a table where for each shop combination A-B I see the quantity IN and the quantity OUT:
| Shop_A | Shop_B | Quantity_shipped_IN | Quantity_shipped_OUT |
| Milan | Rome | 10 | 5 |
| Milan | Paris | 50 | 15 |
| Milan | Prague | 8 | 10 |
| Milan | Bratislava | 20 | 18 |
Many thanks in advance
