Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
based on your last reply, it sound like that is an assumption you want to make
yes, that's correct
see attached
see attached