Hi
I have a table of sales by supplier:
| Month | Supplier | Sales |
| Jan | A | 1488 |
| Jan | B | 1301 |
| Jan | C | 1267 |
| Feb | A | 1373 |
| Feb | B | 1307 |
| Feb | C | 1228 |
| Mar | A | 1816 |
| Mar | B | 1101 |
| Mar | C | 1885 |
| |
And a table of sales by customer:
| Month | Customer | Sales |
| Jan | X | 2668 |
| Jan | Y | 978 |
| Jan | Z | 410 |
| Feb | X | 815 |
| Feb | Y | 348 |
| Feb | Z | 2745 |
| Mar | X | 1515 |
| Mar | Y | 1734 |
| Mar | Z | 1553 |
I want to create a table that shows sales by customer AND supplier that would look like this:
| Month | Supplier | Customer | Sales |
| Jan | A | X | 979 |
| Jan | A | Y | 359 |
| Jan | A | Z | 150 |
| Jan | B | X | 856 |
| Jan | B | Y | 314 |
| Jan | B | Z | 132 |
| Jan | C | X | 833 |
| Jan | C | Y | 306 |
| Jan | C | Z | 128 |
| Feb | A | X | 286 |
| Feb | A | Y | 122 |
| Feb | A | Z | 964 |
| Feb | B | X | 273 |
| Feb | B | Y | 116 |
| Feb | B | Z | 918 |
| Feb | C | X | 256 |
| Feb | C | Y | 109 |
| Feb | C | Z | 863 |
| Mar | A | X | 573 |
| Mar | A | Y | 656 |
| Mar | A | Z | 587 |
| Mar | B | X | 347 |
| Mar | B | Y | 398 |
| Mar | B | Z | 356 |
| Mar | C | X | 595 |
| Mar | C | Y | 681 |
| Mar | C | Z | 610 |
I have no other information to link the 2 tables other than date as it's just forecast information. How is this possible?
Thanks
