I have a question - both tables have sales but one is for customer and the other is for supplier - If you wnated to put everytung in one table, wouldnt you need sales for both?
if you wnat to create one table from 2 and you want columns from both, you would need to do a join
Its just forecast information so I have sales by customer or sales by supplier but I don't have both. That's what I want to create in the script. A join doesn't work as I get null values for supplier where there is a customer and vice versa
based on my data in January supplier A supplied 36.7% of all sales in January therefore supplier A sold 36.7% of sales to customer X. 36.7% of 2668 is 979. Does that make sense?
I think without knowing which supplier supplies to which customer and the value of sales between them, it wouldn't be possible to create the right model.
I just want to assume that proportion of sales by supplier applies to each individual customer. I know that in January supplier A supplied 36.7% of all sales in January therefore supplier A sold 36.7% of sales to customer X.
I agree based on the numbers in January(total customer sales of 4056) and supplier sales for Supplier A (1488) equates to supplier A accounting for 36.7% of the January. I am not sure that the percentage is evenly split amongst the customers, unless that is a assumption or understanding you have
