Finding Strongest Sales Curve for each Product

[nhewett]

Hello there-

I'm not sure how to proceed here, and thought that I'd ask for help.

I have two data points. The first is a table that has a series of sales curves, based on how items within that category have sold. It has a sales curve ID, and the cumulitive % of stock sold during that time slice.

screen shot of sales curves

The second, is a list of products and % of stock they sold during that same time slice. It contains product ID, and the same cumulitive % of stock sold.

screenshot of product list with % sold

I'm wondering how to develop a formula that analyses each product, and matches it to a sales category based on the strongest correlation between all time slices.

Is there a way to do this?

Appreciate the help!

-Nate

[amitchandak]

@nhewett , how you want to connect? provide expected output

You can have a calculated column.

You can move data in 4 ways from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

in the way where we use explicit join, we can use <= and >=  to create between too.