Forum Discussion
cdawidow
Helper III
Helper IIIHow 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 many times a specific product within a contract was sold. I am running into a brick wall in coming up with a formula. Any ideas?
The ORDHDT01 is my sales table and the Detail table is my contract detail table
2 Replies
- AllisonKennedy
Community Champion
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? - AnkitKukreja
Super User
Hi cdawidow
Please go through the article shared by Greg, in order to get your questions resolved in a timely manner, and I feel this apply generally to every situation when you're asking some questions and audience is unaware about your data and model, please share details as much as possible to get this resolved.
