Utilization Rate based off of Inventory Allocations & Next day Sales

[AlexAlberga727]

Folks - 

I need some assistance attempting to calculate how many sales there were for the 'Next Day's Sales' for each SKU, with a Customer Filter.

Currently I have a table indicating allocations per SKU by day. See the below table I have created.

I'm now attempting to bring in the associated sales for the next day to create a utilization rate. However, once I try to bring in the sales It seems to provide a SUM for the entire day's sales - Not broken out by Customer.

If any additional Information is needed, please let me know. Thanks in advance!

[stevedep]

How does your data model look like?