Forum Discussion

cdawidow's avatar
cdawidow
Icon for Helper III rankHelper III
5 years ago

How to filter another Table with shared values?

Hi guys, I have a 2 tables one that stores product details based on specific contracts and a sales history table.  Both have of course shared values in product numbers but I want to calculate how man...
AllisonKennedy's avatar
AllisonKennedy
Icon for Community Champion rankCommunity Champion
5 years ago
cdawidow I need more information to help understand your question better please - which column is the ProductID and what's the difference between the detail (History) and ORDHDT01 (sales) tables? It seems like for this question you don't need the sales table? Just the History? Maybe?