Forum Discussion
melodypoh
8 years agoFrequent Visitor
Create relationship without unique IDs
Hi, I am trying to compare sales from August 2017 (file 1) to August 2015 and 2016 (file 2). I can't connect them because there are duplicated SKUs sold all the time. How would you guys may go about ...
Anonymous
8 years agoNot applicable
Connect them both to a shared calendar table that contains all dates for both years, then compare Augusts from there.
melodypoh
8 years agoFrequent Visitor
Hi there, thanks for your help. I am gonna have to look into how to create a shared calendar table.